I'd try to keep my data on one worksheet. Then use Data|Filter|autofilter to
display/print what I want.

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

wrote:

I hope someone can help me with this as simply as possible. I would
prefer to stay away from VB (don't know how to use it very well), but I
will do what I need.

I have a excel sheet (Sht1) that lists out the assets owned by a
family. Column A is the Asset Name (IRA 1, IRA 2). And Column C
indicates which family member owns the Asset (John, Jane)

I need to keep this list intact and unsorted on Sht1 - 'Sht1' is an
input sheet that will vary in length. However, I want to be able to
relist all of John's assets on 'Sht2' and all of Jane's assets on
'Sht3'.

Sht1:

___A___ ___B___
1| Asset Name Asset Owner
2| IRA 1 JQD
3| IRA 2 AFD
4| Roth 1 JQD
5| Roth 2 JQD
6| Brok 1 JQD
7| Brok 2 AFD

**I want this sheet to be a 'cell reference' of inputs for two other
sheets.

I want 'Sht2' to look like:
___A___ ___B___
1| Asset Name Asset Owner
2| IRA 1 JQD
3| Roth 1 JQD
4| Roth 2 JQD
5| Brok 1 JQD

and 'Sht3' to look like:
___A___ ___B___
1| Asset Name Asset Owner
2| IRA 2 AFD
3| Brok 2 AFD

Here's the major twist, the number of owners will always be two (JQD or
ASD), but the number of Assets and the quantity owned by each owner can
vary. Is there a function that will place them on the separate pages?

--

Dave Peterson