VBA- Copy data and save as new workbook with date as savename from copied dataset

[learn86]

Hi there,

I am very new to excel VBA and was struggling to do the following through codes:
1) Autosort by date.
2) Copy dataset by date and paste it in a new workbook.
3) Remove date column from new data.
4) Save the new workbook with date as naming convention for saving.

I am giving the the screenshot links below to visualize this better:

1. The dataset sorted by date
https://imgur.com/a/cCBPuoz

2. Filter by date and copy or copy until next date change
https://imgur.com/a/QsiEyLI

3. Open new workbook, paste and remove date column
https://imgur.com/a/klG3zow

4. Save the workbook by date name (repeat entire process until last date in the dataset)
https://imgur.com/a/qztRxew


Please help.

I do hope I have been able to articulate what I intend to do.

Thanks in advance.

 

[mole999]

a way to learn is to start the macro recorder, bottom left of screen, perform the action you want to occur one step at a time, stop the recorder, and look at the code

 

[learn86]

Hi,

Thanks! I have tried that however, getting stuck (as in no clue on what to do next) when I want the macro to automatically select data until next change in date as well as naming the file according to the date for which the data has been copied into.

a way to learn is to start the macro recorder, bottom left of screen, perform the action you want to occur one step at a time, stop the recorder, and look at the code