VBA macro that sorts data correct

**MartinDenmark** · 03-09-2015, 07:52 AM

Hello.

I need a VBA code that can sort the following data seen in the attached file.
This is of cause just a simple version of my real dataset which is much larger. Anyone that is smart enough to make this simple macro?

Best Regards

**Alf** · 03-09-2015, 09:52 AM

It's much better to upload a file showing before and after instead of an image if you wish for help.

I see from your forum info that your Office version is "Mac 2011" so you need a macro for "Mac" environment then?

Alf

**MartinDenmark** · 03-09-2015, 09:56 AM

Hello.
This is the file. Do you know what to do? It doesn't matter if it is a Windows file for me.
https://www.dropbox.com/s/bgsv27lpgn...help.xlsm?dl=0

**Alf** · 03-09-2015, 10:38 AM

Do you know what to do?

Not sure, in order to sort the data there must be some system / order in how your data is distributed in the spread sheet.

So is it always (going from left to right) a date column, then values then an empty column, then a new date column, values in a column then an empty column and so forth?

Alf