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

NickMc13 wrote:

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?

--

Dave Peterson