Hi,
I have a formula that a great moderator came up with but I'm afraid it needs tweaking beyond my abilities. The formula is is a multisheet workbook - the formula will find a 'code' on the entry sheet and insert the associated number of hours into the tracking sheet (it is for tracking over-time hours). This was great until I came across a day when the person needed 2 different codes to be pulled from the entry cell (currently, the formula looks for the the code [shown in G3] in the range C13:P13)
Here is the formula:
Since it is looking for a vaule based on the premise that there would only be 1 code in the entry cell, in the format of "##[space]CODE" I am suck...I can arrange for the data to be entered in any form, such as:
10 STAT, 14 AC
or
10 STAT
14 AC
dummy workbook attached - thanks in advance...
Bookmarks