New question

[Lcook]

I am looking to create a payroll sheet. In order to do so I need to have four cells hold their value and only change when a new amount is input.
So I need 4 cells to hold their Year-to-date total for: Gross pay -Medicare - FICA - Federal.
I need the totals in each cell to change respectively as the Gross income is changed week to week. This is how I can do one number but I need to do 4 on the same form. Example-----
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$7" Then Range("G7") = Range("G7") + Target.Value
End Sub

This will hold one cell. I need to hold 4 cells. Can someone please help?
Thanks
Larry

[gmr4evr1]

Just add the same If statement in the same Sub for the others, just change the Cell ranges.
For example, if you want to have D7 as the target cell, and E7 as the cell that changes, use

Please Login or Register  to view this content.

Right after the 1st If statement.

[Lcook]

Thank you much for your help. I thought maybe the answer would be easier than I expected.
Appreciate it!!!

[gmr4evr1]

You're welcome. Glad I was able to help.