Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from 1 sheet to multiple worksheets
I have data in columns in one worksheet
each set has two columns separated by a blank column I wish to copy both columns of each set onto a new worksheet (renamed with Row 1 name) A B C D E F G H more data accross 1 XX YY ZZ 2 Y 91 A 5 D 55 3 Z 92 B 6 E 66 columns C, F, I etc are blank - separating the data i.e. create new worksheet labelled "XX" with columns A and B pasted in A and B and new worksheet "YY" with columns D and E pasted in A and B and new worksheet "ZZ" with columns G and H pasted in A and B looping through all the data in the sheet (over 600 sets) any help appreciated thanks Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create copy of multiple worksheets and automatically fill in datafrom a main sheet | Excel Programming | |||
Insert formula in multiple worksheets & copy output to new sheet | Excel Programming | |||
copy data across worksheets and add multiple lines | Excel Programming | |||
Copy data in multiple worksheets | New Users to Excel | |||
Copy only certain data from multiple worksheets | Excel Discussion (Misc queries) |