Hi all,


I run a report at work which I export into excel for further analysis. All of the data is presented fine in rows across. However one piece of data, i.e. the Account Number, which is a six digit number. This only appears once for each subset of data and I need to put this account number adjacent to each line item.

I realise this probably needs a macro but am not sure how to do this. I think I would need to add a loop, but I am a bit of a novice with vba and macros.

May be an offset forrmula could be written? Because the account number is consistently presented in the same location, however each set of company data varies in length.

I have attached an example (obviously the data is made up, but this is the exact way in which my report is presented). I have highlighted in yellow where each occurrence of the account number is and at the moment I have to manually copy that number to where I have highlighted in green. This is a shortened version of the data set and in reality there are several hundred Companys and thousands of line items

Any help would be greatly appreciated or even the code I could use

Thank you

Attached Files

example.....xlsx (12.4 KB, 51 views)