Hi,
I have a problem with a report I am converting from PDF to Excel.
The problem is, it doesnt recognise certain data correctly and as a result columns are merged which distorts the data.
In the attached I have shown the orignal report in columns A:H along with what I need in J:Q. I have used formulas for this but ideally would I would like is a code that would work and do this for me, can anyone help please?
One thing to note is that I wouldnt want the data in column J:Q - I would like it to replace the orignal data table A:H
Please note in my data i have manually inputted the sub totals manually - ideally I would like the code to do this. A similar code was supplied on a different post for this here (I just need to work out how it works)
Any suggestions are very much welcomed.HTML Code:
Bookmarks