copy one row at a time to different worksheets
I have a master list with 40 rows of information and need to copy one row at
a time to 40 different worksheets. For example Row 24 needs to be placed in worksheet 1; Row 25 to worksheet 2; Row 26 to worksheet 3, etc. I know how to copy/paste but is there a formula or macro to that I can use so I am not copying/pasting for a life time? Thank you |
copy one row at a time to different worksheets
You would use a macro for that. What is the logic that this row goes into
that sheet? Is there information of some kind in some column that dictates the destination sheet of that row? HTH Otto "Roxie720" wrote in message ... I have a master list with 40 rows of information and need to copy one row at a time to 40 different worksheets. For example Row 24 needs to be placed in worksheet 1; Row 25 to worksheet 2; Row 26 to worksheet 3, etc. I know how to copy/paste but is there a formula or macro to that I can use so I am not copying/pasting for a life time? Thank you |
All times are GMT +1. The time now is 04:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com