Looking portential formatting macro to include specific sales copy and paste.

Hello Excelforum,

I have been using excel quite a lot in the last 3 years but have mostly just used the general formulae in the certain cells required. I am attempting to increase my excel skills by potentially learning some macros and programming skills. I understand there are other threads related to introductory VBA and macro works which I have had a look at.

Unfortunately I have not been able to find a specific solution to the problem I am facing. I have uploaded a sample spreadsheet of what I am requiring and am wondering if it would be possible to use a macro to make my work a lot easier.

Their are certain reports which I can import into excel for work which are very useful, but I would also like to manipulate these reports to analyse the data in a different way.

Basically what I require to do is to insert a new column on the left of the rest of the works and fill this column with the associated customer name so that each row of data has an attachment to the customer and not just under the customer's heading (I hope this makes sense). Once the customer's name has been added in the new column for each row of purchases, the row which contains the customer's name will then be deleted.

Let me know if this can be done efficiently with a macro or if some other programming may need to be rquired. Once again the inital report style is in the attached spreadsheet and a sample of what I am after is on another page of the same spreadsheet.

Thank you in advance,

Lachy725