Macro to update the cells!!

[ckmoied]

Hi all,

I am trying to build an inventory in excel. I need a macro to do the following.

I have inventory database in sheet1, and invoice in sheet2. Now I put the desired items from sheet1 into sheet2 by using VLOOKUP function. But once I change the stock value in sheet2, I want the corresponding change appear in the corresponding cell of sheet1.

Any suggestion.

 

[Bozacke]

CK,

A little more detail on what you're trying to do?