Copy paste rows in Excel across worksheets
Solved/Closed
LBlanco
-
Sep 28, 2011 at 12:02 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 28, 2011 at 04:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 28, 2011 at 04:49 PM
Related:
- Copy paste rows in Excel across worksheets
- Number to words in excel - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 28, 2011 at 06:26 AM
Sep 28, 2011 at 06:26 AM
Copying row at a time does not sound like a good idea on surface. I would suggest you do this
1, Filter the 3 sheets on "non blank"
2. copy the visible row from sheet1 on to the new sheet
3. in the new sheet where data was pasted, mark all the rows in serial number ( 1 to N) and in another column mark it as set A
4. Copy the visible row from sheet2 and paste right after the last row pasted earlier. Mark all these rows as set B and mark the serial number of this set too (1 to N)
5. copy the visible row from sheet3 and paste right after the last row pasted earlier. Mark all these rows as set C and mark the serial number of this set too (1 to N)
6. Now sort the data on new sheet on serial number and secondary sort on set source
1, Filter the 3 sheets on "non blank"
2. copy the visible row from sheet1 on to the new sheet
3. in the new sheet where data was pasted, mark all the rows in serial number ( 1 to N) and in another column mark it as set A
4. Copy the visible row from sheet2 and paste right after the last row pasted earlier. Mark all these rows as set B and mark the serial number of this set too (1 to N)
5. copy the visible row from sheet3 and paste right after the last row pasted earlier. Mark all these rows as set C and mark the serial number of this set too (1 to N)
6. Now sort the data on new sheet on serial number and secondary sort on set source
Thank you, that worked great.
Mark
Mark
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 28, 2011 at 04:49 PM
Sep 28, 2011 at 04:49 PM
You are welcome Mark. Good luck.
