Please help create a macro that would update my data on a daily basis in sheet 2. If there’s an input data in “item no.” in sheet1, it should be copied accordingly in sheet2 whereas the date must be updated also.
Please refer to those tables below:
Sheet 1:
PRODUCT NAME unit amount item no.
product 1 20
product 2
product 3 10
product 4
product 5 9
product 6 9
product 7
product 8 6
product 9
product 10 8
Sheet 2:
DAILY RECORD
PRODUCT NAME 02/03/12 date date date date date date date ...
product 1 20
product 2 0
product 3 10
product 4 0
product 5 9
product 6 9
product 7 0
product 8 6
product 9 0
product 10 8
Bookmarks