If Date

[Jeff Mackeny]

how can I make a formula work only from a specific date on, for example I
have a list of people who pay the same X amount of money each month, so I
have 12 sheets for each month and then one MasterList sheet, in the
MasterList C4 I enter the amount for the person and so on, then on all
other sheets I enter =MasterList!C4, then I have a SnapShot sheet that sums
all balances from all sheets for each person, which means that say I collect
from person B4 $100 a month, it will instantly show the person has a balance
of $1200.00, so I need to set the Feb sheet to show =MasterList!C4 starting
02/01, the Mar Sheet starting 03/01 and so on...

Thanks

 

[Frank Kabel]

Hi Jeff
not really sure what you want to achieve on your sub-sheets. How is
your master sheet designed (what columns do you have on this sheet).