Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create and name a new workbook based on each unique record
HELP,
I am a sales analyst and every month I have to go through a list of leads from the whole USA and create a new file for each state. Usually I use the auto filter and copy all the records for a individual state onto a new workbook which I name with the state abbreviation. I would like to run a macro that will group all the records for a individual date together and automatically create a new workbook named with the value of cell that contains the state abbreviation. Is that possible? -- 10READ1010101010101010101010101101010BETWEENt10101 01010101010101010101101010THE101010101010101010101 0101101010CODE0101010101 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create and name a new workbook based on each unique record
Hi code_hungry
See this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "code_hungry" wrote in message ... HELP, I am a sales analyst and every month I have to go through a list of leads from the whole USA and create a new file for each state. Usually I use the auto filter and copy all the records for a individual state onto a new workbook which I name with the state abbreviation. I would like to run a macro that will group all the records for a individual date together and automatically create a new workbook named with the value of cell that contains the state abbreviation. Is that possible? -- 10READ1010101010101010101010101101010BETWEENt10101 01010101010101010101101010THE101010101010101010101 0101101010CODE0101010101 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find earliest record based on unique identifier from a list ofdata | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
how do I create a template that gives each record a unique number? | Excel Worksheet Functions | |||
EXTRACTING UNIQUE RECORD BASED ON CONDITION | New Users to Excel | |||
EXTRACTING UNIQUE RECORD BASED ON CONDITION | Excel Worksheet Functions |