Hi all
I've tried searching the forums but with no success.
I'm working on a macro which will basically pull in stock levels based upon the product code.
I will use windows scheduler to open and run the macro on a daily basis.
But I want the stock levels pulled into a new column and the macro to insert the current date at the top of that column.
So for example, A2 to A100 will have unique product codes. The macro will then run a vlookup formula to search stock quantity from another workbook, and insert the corresponding stock levels into B2 to B100.
The next day when the macro runs, I want it to insert the date at the top of the column, run the vlookup and insert the stock levels below that date.
So for each day, I'm recording stock levels for that day for each product.
Hope that makes sense, any help greatly appreciated.
Thanks
Andy
I've tried searching the forums but with no success.
I'm working on a macro which will basically pull in stock levels based upon the product code.
I will use windows scheduler to open and run the macro on a daily basis.
But I want the stock levels pulled into a new column and the macro to insert the current date at the top of that column.
So for example, A2 to A100 will have unique product codes. The macro will then run a vlookup formula to search stock quantity from another workbook, and insert the corresponding stock levels into B2 to B100.
The next day when the macro runs, I want it to insert the date at the top of the column, run the vlookup and insert the stock levels below that date.
So for each day, I'm recording stock levels for that day for each product.
Hope that makes sense, any help greatly appreciated.
Thanks
Andy