Excel 2007 : Running Total in one tab that comes from another tab based off of a specified cell value..

[Imsonny]

I have a value in a tab called “JOB #'S” in cell (D8) let’s just say that value is “1000”. This same value appears in another tab called “PURCHASE ORDERS”. If the “1000” value does appear in the “PURCHASE ORDERS” tab it would be in column (I) starting at row (7). Now this value will not just say “1000” it would appear as “XX-XX-1000” or “XXXX1000”. It also has the chance of appearing multiple times in various rows but always in column (I). If there is a value of “1000” in (I7) or any other row, I would want the value of the cell to the left (H7) to be added to a running total in a cell back in the “JOB #'S” tab let’s just say (O8). If this possible with either a formula, or a macro. Please let me know.

Thank you for taking the time to read my post

Sonny