Text to multiple worksheets?

[Guest]

I have a multiple Row and Colunm worksheet. I want to write a macro or
perform a function.. For every change in Column A, Place data on a different
worksheet.. For example
If A looked like:

1
1
1
2
2
2

The 3 , 1's would go onto a new worksheet with the information in the rows
along with the 2's on another worksheet..
Any help would be greatly appreciated!

 

[Dave Peterson]

I'd keep all that data in one worksheet if at all possible. If someone updates
the "child" worksheet and expects you to update the "parent" worksheet, then
you'll find that it turns into a mess.

But if you're generating those worksheets for just reports...

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

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

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm