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 -
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.