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 |
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 |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com