Copying Customer Details Onto Each Sale Line Until Next Customer is Reached

Hi
Hoping this is not going to be too difficult. Have tried to Google the question but not actually sure what I am asking for lol.

I have a huge report which has been sent to us by one of our distributors, which has been formatted by whichever reporting software they use.

I am able to edit the report to give me all the information I need using a macro but need one last bit.

In a nutshell, I need the Account Ref and Name to be copied down as a new column for each Stock Code item underneath it until it gets to the next Account Ref. Once copied I would like to remove the original Account Ref and Name cells to leave a standard Excel spreadsheet that can be uploaded to another system.

I have attached a sample sheet of dummy data (minus a few columns at the end) which should illustrate my problem.

Any help would be greatly appreciated.

Thank you

As far a I know, yes

Thanks xlbiznes
Will take a look today and let you know if it does what I need

Thanks xlbiznes
Code was brilliant!
Adapted it slightly to give me exactly what I need for the full completed report and it works beautifully
Here is the amended code for anyone that might need something similar in the future