Need Macro

[ckmoied]

Hi all,

I am trying to build my inventory in excel and need some help, to do two of the follwing tasks with one click of the button.

Task 1) I have an invoice template in sheet2, and everytime I issue an invoice I want it be saved with "Date of Issueance" as its name.

Task 2) I want to update the inventory once I issue the invoice.

Suppose that I have new inventory balance in cells B2 and B3 on sheet 2, now once I press the the button the corresponding cells in sheet1 must get updated simultaneusly.

I am already using VLOOKUP function to locate inventory items from sheet1 and put them in apprpriate cells in sheet 2.

can anybody provide help on developing this sort of macro.

Thanx

Khurram Moied

 

[ckmoied]

Sorry, here is additional information.

The refernce of searching item from Sheet1 is the code number of the item that I want to include in my invoice. such that in sheet 1, column A has the code number, B has the name of the item, and C has the balance quantity.

Now I am using VLOOKUP function on sheet 2. Such that if enter the code number then the name and quanity automatically comes from sheet 1.

However once I issue the invoice, I want the corresponding cells in col C of the sheet 1 to get update for the new balance.

Thanx