Macro to Group, Label and draw borders

Hello all,

On the attached example, I would like a macro that makes sheet1 look like sheet2.

The rows need to be grouped by the load data (Column A). I would then like a column inserted to the left of this that is merged to create a vertical label for all rows with the same load data (as shown in sheet2).

Once this task has been performed, I would like borders to be drawn around all cells and then a thick border drawn around the grouped, load data.

The number of different loads and rows of data will vary each time I run the macro.

I have no experience on creating macros so any help is greatly appreciated.
thanks,

From where the load is coming on sheet2 from sheet1 ?? Where are these numbers in sheet1

Load
456
456
456
789
789
789
789
789
987
654

Sorry - attached the wrong file.

The correct file is now attached.

Check this attachment and code

Please Login or Register  to view this content.