Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 216
- Office Version
- 2019
- Platform
- Windows
I dont have much knowledge about VBA codes
I have a particular cell B19 where I put texts and the cell text changes repeatedly according to the input. I want to copy the text from the B19 to other sheet named "Print" when I click the click button.
for example, now in the cell B19 the text is Ram, if i click the button the text Ram will be saved on B1 of Sheet named "Print" then subsequently I put text Ram2020 and will click the button then the text will be saved on B2 of "Print" sheet.
I have a particular cell B19 where I put texts and the cell text changes repeatedly according to the input. I want to copy the text from the B19 to other sheet named "Print" when I click the click button.
for example, now in the cell B19 the text is Ram, if i click the button the text Ram will be saved on B1 of Sheet named "Print" then subsequently I put text Ram2020 and will click the button then the text will be saved on B2 of "Print" sheet.