Hello Everyone,
I have two sheets in a workbook (Inv and Pslip)
I'm trying to make a macro which will lookup a part number from a specified cell in Pslip and locate the same value from the first column of Inv, and reference the value of the second column of Inv at the particular row.
Secondly I was hoping to change the value of the referenced cell in Inv, by subtracting from it, the value of the same row but the second column of the specified cell in Pslip.
Writing this has even confused me somewhat... I hope that what I hope to accomplish is understandable.
I have written the lookup, but have not yet figured out how to determine the location of the referenced cell in Inv or how to change the cells value.
I used Vlookup for the lookup.
Thanks,
Any suggestions would be much appreciated.
I have two sheets in a workbook (Inv and Pslip)
I'm trying to make a macro which will lookup a part number from a specified cell in Pslip and locate the same value from the first column of Inv, and reference the value of the second column of Inv at the particular row.
Secondly I was hoping to change the value of the referenced cell in Inv, by subtracting from it, the value of the same row but the second column of the specified cell in Pslip.
Writing this has even confused me somewhat... I hope that what I hope to accomplish is understandable.
I have written the lookup, but have not yet figured out how to determine the location of the referenced cell in Inv or how to change the cells value.
I used Vlookup for the lookup.
Thanks,
Any suggestions would be much appreciated.
