Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / December 2007

Tip: Looking for answers? Try searching our database.

Excel 2003 - VBA - Formula disassembly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
C Brandt - 31 Dec 2007 19:27 GMT
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 - 31 Dec 2007 19:44 GMT
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

> I have an interesting problem.
>
[quoted text clipped - 27 lines]
>
> Craig
CLR - 31 Dec 2007 19:47 GMT
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

> I have an interesting problem.
>
[quoted text clipped - 27 lines]
>
> Craig
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.