Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lost in Windows
 
Posts: n/a
Default 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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
copy ranges from multiple worksheets simora Excel Worksheet Functions 2 May 18th 05 01:42 AM
How do I double-side print multiple worksheets in a workbook? Ohio Office Excel Discussion (Misc queries) 2 March 3rd 05 08:21 PM
Extracting data from multiple worksheets into a list mnirula Excel Worksheet Functions 16 February 25th 05 09:52 PM
Multiple Worksheets in a workbook Bill Healy Excel Worksheet Functions 7 November 13th 04 02:04 AM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"