create multiple worksheets in workbook from one csv file

G

Guest

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
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to merge worksheets - Excel 2003 0
Import Multiple CSV Files from Same Folder into Open Workbook 5
Create workbooks from worksheets 3
consolidate workbooks to worksheets in one workbook? 1
multiple workbooks in one file 3
Linking multiple worksheets in one workbook 2
Convert Excel workbook in to .csv format 1
Convert csv to Excel files 1

Top