Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Pull data from sheet 1 to sheet 2Posted by noir on November 09, 2001 10:56 AM
I have by data setup like this in sheet 1:
I would like to use =sum(if(payee="cash",amount,0)) to keep a running total of the cash i spend but, i do not know how to incorporate sheet 1 into the formula.
|Check out our Excel Resources
Re: Pull data from sheet 1 to sheet 2Posted by noir on November 09, 2001 10:58 AM
PS, i will record all sheet 1 cash totals from within sheet 2.
Re: Pull data from sheet 1 to sheet 2Posted by Aladin Akyurek on November 09, 2001 11:08 AM
Would it be:
what you want to do?
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.