Previous Topic Next Topic

Excel copying text

Closed
Rosa - Apr 22, 2010 at 09:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 22, 2010 at 12:49 PM
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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 22, 2010 at 12:49 PM
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.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response