K
kastnna
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?
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?