Hi,
I would please appreciate if someone could help me with writing vba script for my below project.
I basically have two sheet, Data and Summary
On Data sheet, i have items and their quantities with specific date on top
On summary sheet, i have items with date range, and index match formula in Cell A1
I would like to create VBA Script to match date between both sheet and then copy index match formula from Summary sheet A1 and paste on to matching date column on same sheet, after pasting formula i want that column to be change with paste special value.
Attached is the example file, i would really appreciate if someone could add script on this file and attached back here.
thank you for help.
regards
Nadim
Bookmarks