sort data from 1 sheet to multiple sheets in excel

[NickMc13]

I have a master sheet with 6 columns and 20 rows. I will be adding about
200-250 more rows to this. I would like to be able to add these rows and
have the info populated into one of 14 other sheets automatically. I found a
way to do this by adding a macro but I have to click that after each row is
added. Is there any way I can set up something to do this for me as I enter
the data?

 

[Satish]

I have a master sheet with 6 columns and 20 rows.  I will be adding about
200-250 more rows to this.  I would like to be able to add these rows and
have the info populated into one of 14 other sheets automatically.  I found a
way to do this by adding a macro but I have to click that after each row is
added.  Is there any way I can set up something to do this for me as I enter
the data?

Do you wish to paste those 250 rows and then execute a macro that will
automatically put all your master data into various other sheets? If
so, and if you know under what conditions, each row needs to go to a
specified sheet, then it can definitely be done using some
programming. Let me know your exact requirement and we can see how
to do it.

Thanks
Satish

 

[Dave Peterson]

Saved from a previous post.

Excel doesn't do this kind of thing very well.

If you make a typing mistake, you'll have to provide code to remove the new
entry from the wrong sheet.

Instead, I'd keep all the data in one sheet. Use autofilter or sort to show the
stuff I need.

But if I needed separate worksheets, I'd refresh them from scratch each time I
needed them.

You may want to look at how Ron de Bruin and Debra Dalgleish approached this
kind of thing:

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

Or:

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

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