Macro to merge and Center varied range of data in a fixed row

Hi Everyone,

Please see attached the example worksheet. I am wondering if there is a way to write a macro that will change data from individual strings within a cell row to merged and centre data for that set of data. The issue is the data in the row will be varied i.e. sometimes there will be 20 x 2013 other times there may be 22 X 2013 etc. however, the data will always be fixed in the same row on the worksheet.

At the moment the best I have is a recorded macro, which really doesn't work too great and I end up fixing it constantly.

Any help would be greatly appreciated.

Thanks!!

This should do

Please Login or Register  to view this content.