direct deposit scenario

  • Thread starter Thread starter john
  • Start date Start date
J

john

Hi, working on my own employee payroll sheet and I have 3
questions:

1. I have an employee who wants thier direct deposit
split by way of only $75.00 into one account and the
remainder balance into the 2nd account.
So: what I have now is this d16 is the final net
income cell for employee-x, d17 is the cell I'd like to
place the balance(-75.00) and d18 is the cell I'd like to
place the 75.00

2. How do I do an accumulative total on cells or columes,
not auto, but manual so that when I choose too I can
update the running total of somthing like year to date?

3. How do I clear the whole workbook, save it with a date
(week ending xx/xx/xx)and possibly tie that action with
saving the accumulative totals with out eraseing all the
formulas?

Thanx for any help at all
JOHN
 
1) In d17 =d16-d18
2) Enter a formula in a cell.
3) Create a workbook with all the formula and no data. Save it. Open it when
you need a new workbook and do a save as newname.
Then enter the data.
 
Back
Top