Hi All,
I am struggling to create a code by which I can copy the data from defined date ranges(start date and End date) and pasting the data with respective dates in new sheet. I have two sheets with name
1. sheets("Dashboard")
2. sheets("Copied data").
The sheets("Dashbaord") contains the buttons whereas the sheets("Copied data") contains data. My idea is to define a start date and end date in sheets("Dashboard"). The start date will be in cell J15 and End date will be in J16. The date column is present in the first column of sheets("Copied data"). By starting the code it should copy the date range (all dates between the defined date range) and respective data in column B and column C from sheets("Copied data") and paste it on another new sheet.
The code is as below:
I ll appreciate any help in this regard!
Thanks
Bookmarks