Excel 2003 - VBA - Formula disassembly

[C Brandt]

I have an interesting problem.



I have two tables exemplified by the simply example below.

The first is a listing of all accounts while the second is the summation of
those account into family groupings.



1 SMI123 $1234.00 John Smiths IRA

2 SMI321 $4321.00 Jane Smiths IRA

3 THO987 $ 234.00 Sam Thomas Roth





500 CSMI01 =B1 + B2 Smith's Family Total

501



What I would like to do is create a third table that takes the formulas in
the second table and determine and make up a list of the accounts that make
up Family Totals.



1000 CSMI01 SMI123 SMI321



How does one gain access to the formula in B100 rather then the result of
that formula?



Or is there an easier way to accomplish the task?



Thanks,



Craig

 

[CLR]

This could be done using the Subtotals feature, or perhaps Autofilter, but
you would need to add an extra column to provide a "Family name" for each
entry.......Excel does not know automatically that John Smiths and Jane
Smiths are related, and that Mary Smiths is not.


Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Thanks for the Thanks, Craig.........it's always nice to hear that our
efforts do help folks.

Happy Holidays to you and yours as well........

Vaya con Dios,
Chuck, CABGx3