Hello all,
I am asking for help in a date related macro issue.
I will be receiving a large amount of data on a daily basis soon, that I need to segregate into weekly sheets in the same workbook.
My week will start every Monday, and end every Sunday.
I would like to have a macro that will go to sheet "IMPORT" and pull data specified between the two dates in F3 and F4 and populate rows starting in A20:F20 to of every sheet.
From column G:L, I will like to place the code to copy the formulas down, for the new data
I have recorded macros for each sheet, and hard coded each sheets date into the macro, but I would like to have the code look up the dates in F3 and F4 in the "Activesheet", then go to the "IMPORT" sheet and copy the data from there, so I only need one macro, and not 52.
I have tried to manipulate some codes I searched up, but I just can't seem to get it right.
Your help is much appreciated
Bookmarks