Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating unique new worksheets
I have a large list of data from a database, and need to turn that into
worksheets in a larger VBA macro (as there are many other things that I need to do with it in the future). It consists of a person's name, and then many pieces of data afterwards. The data also comes out by week, so names are often repeated. something like this: NAME Var1 Var2 Var3 etc week number Person1 data data data 10 Person2 data data data 10 Person3 data data data 10 Person1 data data data 9 Person2 data data data 9 Person3 data data data 9 Person1 data data data 8 etc... I would like to be able to make a new worksheet for each person in the overall list, and copy all of their data over to their new worksheet, in an arbitrary cell number. Thanks in advance. --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date formating, creating unique calender | Excel Worksheet Functions | |||
Creating a Unique List | Excel Discussion (Misc queries) | |||
Creating a Unique Reference from 2 cells | Excel Discussion (Misc queries) | |||
Creating A Unique List of Values From A Table | Excel Worksheet Functions | |||
Any Way of Creating a 'Unique Key'? | New Users to Excel |