Formula
I have a spreadsheet that I would like to automaticlly update whenever
I cut and paste data into a new tab.
Each billing is identified by a number
1051-520-39
1052-009-39
1052-007-39 and so on
So when I get an employee's new expense report, I want to put in that
data into a master table and have it updated automaticlly, only when
the numbers match from that employee expense report into the new
master.
I thought I had it working, can anyone here help?
Example below of all fields.
Charge/TO Number Straight Time Hours Over Time Hours ST/OT Double
Time ST + Height Pay Paid Leave Cost
0100-000-00 Paid Leave $21.55 $-
1050-31B-39 Adm. Leave 0.00 $21.55 $-
1051-520-39 0.00 $21.55 $-
1052-007-39 0.00 $21.55 $-
1052-009-39 0.00 $21.55 $-
1052-011-39 2.00 $21.55 $43.10
|