Home

Excel VBA

darkgyft
New Contributor

I have a worksheet that keeps track of labor.  When we take a new job, labor gets added to it, and when we complete portions of the labor, or ship a completed job, the labor comes off.  What I'd like to do is keep track of labor as it happens.  We run into a problem when we ship lets say a job that has 10 hours of labor on it, and then take on a job that has 10 hours of labor on it in the same day.  The number changes, but changes back to the original amount, so we don't know how efficient jobs are moving through production.  I'd like to record any increase changes to that number in one cell, and any decreases to that number in a different cell.  For a twist, I want those changes to change throughout the week, as long as TODAY()'s date is before a date I have listed in another cell.  Does this make sense?  I'd rather not post the worksheet to the forum, but will send it to someone directly.

 

Thank you

Related Conversations
Getting #Value!
ranjit995 in Excel on
2 Replies
pratica 1002380750 - query web
Ben_Hur in Excel on
1 Replies
Custom Sheet View is not working in Office 365
RonanK in Excel on
1 Replies
help with macris & VBA
Adil_813 in Excel on
0 Replies
How to count average in certain time range
rutilusss in Excel on
1 Replies
Subtotals or Vlookups or Both.
Kwesi_Quartey in Excel on
7 Replies