H
handyaccountant
In Column B I have Sales, Column C Sales Tax and Column D the anticipated
deposit (combination of the two). These columns are broken down for daily
totals in rows 4 thru 34 (1-Jan-08 thru 31-Jan-08).
Further down in the sheet I want to be able to enter into Column D (say row
37) the actual deposit and have cells B37 and C37 populate with the matching
Sales and Sales Tax amount for that deposit
deposit (combination of the two). These columns are broken down for daily
totals in rows 4 thru 34 (1-Jan-08 thru 31-Jan-08).
Further down in the sheet I want to be able to enter into Column D (say row
37) the actual deposit and have cells B37 and C37 populate with the matching
Sales and Sales Tax amount for that deposit