Stock receipt - vlookup/macro

**David_85** · 03-22-2009, 05:01 AM

I am setting up a temporary inventory management spreadsheet until we have new software installed. My main issue is 'automating' stock receipts.

On sheet 1 I have part #, current stock holding and qty on order. When I receive a delivery I need to increase the stock holding quantity by the amount received.

On sheet 2 I enter the part # and the quantity received. A vlookup runs to sheet 1 against part # and returns the current stock holding + what has been received. I now have my new stock holding. I just need to find a way to get it back onto sheet 1.

Would a combination of a vlookup and a macro be the answer here?

**Simon Lloyd** · 03-22-2009, 05:08 AM

If you want the figure to be static after you have recieved stock then it will have to be a macro.....can you supply a sample workbook so we can help you with that?

**David_85** · 03-22-2009, 07:53 AM

Hi Simon,

Thanks for your reply.

Yes the figure would be static. I have attached a sample workbook.

My aim is to get the value in column E of sheet 2 to overwrite the value in column E of sheet 1 for the corresponding part number.

I don't have a lot of experience with macros. When I record them I tend to use absolute references and have difficulty making it relative so that it can work in a different environment...if that makes any sense

Thanks
David