Hi all.
Could anyone please help with formulas using the worksheet calculate event.
In column A of sheet1, product codes are scanned. This then brings details of the items through from sheet2 where the manifest is stored using index match on columns L, M, N, O
What I would like to happen is if the item is found and the details come through, the formulas to be removed and replaced with the values.
Any help would be appreciated if this is possible.
Regards,
Graham
Could anyone please help with formulas using the worksheet calculate event.
In column A of sheet1, product codes are scanned. This then brings details of the items through from sheet2 where the manifest is stored using index match on columns L, M, N, O
What I would like to happen is if the item is found and the details come through, the formulas to be removed and replaced with the values.
Any help would be appreciated if this is possible.
Regards,
Graham
