Hey Guys
The problem:
I have a problem that I hope you can help me with.
I have a workbook it could eg. look like the below picture.
I need a macro that goes through column B, look for all cells with the same date in column B and copies these rows incl header into a new workbook and saves the workbook in a specific file path.
That means the macro needs to save 4 new workbooks as there is 4 different dates in the below
The problem:
I have a problem that I hope you can help me with.
I have a workbook it could eg. look like the below picture.
I need a macro that goes through column B, look for all cells with the same date in column B and copies these rows incl header into a new workbook and saves the workbook in a specific file path.
That means the macro needs to save 4 new workbooks as there is 4 different dates in the below