Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to automatically create and populate worksheets?
I am looking for a way to have excel open and compile separate
worksheets for different values in column A, in a large list of data (about 6000 lines worth). There are about 10 possible values for column A, and I need a separate worksheet for each value, with the rest of the data from that line in that new worksheet. Is there an automated way to do this? - At the moment I am reduced to ordering the worksheet by column A and cutting and pasting the lines for each section onto new worksheets. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically create worksheets | Excel Discussion (Misc queries) | |||
User Name Automatically Populate | Excel Worksheet Functions | |||
make dates automatically populate a cell on different worksheets | Excel Worksheet Functions | |||
Populate lists automatically | Excel Discussion (Misc queries) | |||
How to automatically populate the next available invoice # | Excel Worksheet Functions |