nbqleebarnes
05-03-2014, 07:28 AM
Hi All,
I hope somebody can help, I have been busy for days trying to get this right with no joy.
I am trying to copy a cell value into a table with the relevant corresponding part number.
I have attached the workbook.
I have managed to use a vlookup to locate the relevant current stock part number and qty from the invoice but I am trying to update the stock level from "Sales" "J18" to the relevant part number "i18" stock level in the "Sales" worksheet.
It would be much appreciated if someone can help me.
Thanks in advance.
Lee
I hope somebody can help, I have been busy for days trying to get this right with no joy.
I am trying to copy a cell value into a table with the relevant corresponding part number.
I have attached the workbook.
I have managed to use a vlookup to locate the relevant current stock part number and qty from the invoice but I am trying to update the stock level from "Sales" "J18" to the relevant part number "i18" stock level in the "Sales" worksheet.
It would be much appreciated if someone can help me.
Thanks in advance.
Lee