Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] zephodbeeble@yahoo.com is offline
external usenet poster
 
Posts: 1
Default 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