create multiple worksheets in workbook from one csv file

[Lost in Windows]

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]

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