Excel copying text [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi,

Hopefully someone might be able to help. Can you tell me if I can copy text in one worksheet to another continuously? All the text is in the same row and column, but the length of text varies depending on the comments. I know that ='Sheet2'!A2 will copy the text from worksheet2 to another, but I need to do this continuously through out the worksheets. But cant seem to figure the function -

thanks

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
I am not sure what you are asking. It seem that you want to copy record from one sheet to other one. It can be done. You need to explain with example. Or better. Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!