Hello,

I am running a material tracker in excel. In the workbook I have three sheets: Open Items, Completed Items, Canceled/Rejected. Basically, the open items sheet has too much financial information for the discipline leads offshore to use for scheduling work (older oil dudes dont like computers).

I am developing a new sheet in the workbook titled Tracking. I need it to have just the tracking information ( a few columns ) from the open items sheet.

I pulled the columns over to the Tracking Sheet and put the following function in to the appropriate Tracking Sheet cells: =IF('Open Items'!J3="","",'Open Items'!J3)

This is working, but items from the Open Items sheet get moved over to the Completed Items sheet when delivered and I delete the corresponding rows on the Open Items sheet.
When I do this, the rows on the Tracking sheet show: #Ref

Is there a Macro or correct function I can use to fix this problem?

I appreciate any help.

Thank You