Dynamically create worksheets in Excel based off existing data?
 

I run a huge report monthly that needs to be broken down to several
worksheets within the workbook. I'm manually doing this now and it takes
hours. I start with a signal worksheet that has all my data, then I sort the
data, then I copy and paste to new worksheets. There has to be a way I can
automate this process, please any and all ideas are welcome. Thanks

I'd do my best to keep the data in one worksheet and use filters and sorts to
display what I wanted.

But if you really need separate worksheets, can you pick out a column that
indicates what worksheet should get that row?

Both Debra Dalgleish and Ron de Bruin may have solutions for you:


Debra'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

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

tlozier wrote:

I run a huge report monthly that needs to be broken down to several
worksheets within the workbook. I'm manually doing this now and it takes
hours. I start with a signal worksheet that has all my data, then I sort the
data, then I copy and paste to new worksheets. There has to be a way I can
automate this process, please any and all ideas are welcome. Thanks

--

Dave Peterson