| 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 |
| 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 | |||
Threaded Mode
