Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new sheet
i did not create the worksheet i am working with. The data is organized so
the headings are by row, not column. For example: A B C 1 Commision % 8.2 9.3 2 Sales Rep dave bill 3 Job # 1 2 I need to go through row 2, and make a sheet for each salesman. but it needs to copy the whole column with it. most sheets are set up so these would be the column headings. i don't want to reorganize the sheet by transposing the data, but something like that could be hidden in the code if need be. i'm stuck. so i'd appreciate any help. THANKS, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |