Hi everyone, been a while I was made redundant in 2015 after 41 years the majority of which was spent using Excel. I'm doing a bit of voluntary work for an Association and need a bit of help from the guru's on the forum.
I'm using Office Pro 2010.
The workbook has a Sheet called Download and 12 sheets named Jan, Feb, Mar etc. through to Dec.
I need a macro that will do the following -
Go to the download Sheet and select B6:H6 and to the bottom of the range which will change, at the moment it is row 53 so B6:H53 but next month that will might be H73.
Sort the range newest to oldest based on Column B which has dates in it in this format 02/01/2019 for 2nd Jan 2019.
Then using January as an example work down through Column B and copy columns B:H for any rows with a January date in Column B.
Go to the Jan Sheet and paste into A6 keeping the source formatting. Repeat for every month of the year.
I have attached a sample.
As always many thanks.
Bookmarks