| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| How can I copy multiple worksheets in Excel at the same time? | Excel Discussion (Misc queries) | |||
| How to copy worksheets | Excel Worksheet Functions | |||
Linear Mode
