Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
copy ranges from multiple worksheets | Excel Worksheet Functions | |||
How do I double-side print multiple worksheets in a workbook? | Excel Discussion (Misc queries) | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Multiple Worksheets in a workbook | Excel Worksheet Functions |