create multiple worksheets in workbook from one csv file
I need to create multiple worksheets (one for each store) for a workbook from
a single csv file that contains the location number. Is is possible? If so, how? Thanks |
After you import the CSV file into excel, you could use a macro that would
create those other sheets. I'd steal some code from Debra Dalgleish's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb or maybe Ron de Bruin's easyfilter. http://www.rondebruin.nl/easyfilter.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Lost in Windows wrote: I need to create multiple worksheets (one for each store) for a workbook from a single csv file that contains the location number. Is is possible? If so, how? Thanks -- Dave Peterson |
All times are GMT +1. The time now is 10:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com