In the attached sheets I am trying to re-arrange the data in sheet 1, FEX UTILISATION REPORT.XLSX, so that it looks like the sheet FEX UTILISATION REPORT2.xlsx. I have tried recording a macro, which while successful, is far too long, I am sure there must be a way of repeating the delete, cut and paste commands using some sort of loop.
Any help you can give would be greatly appreciated. This is page one of a 48 page report, data is similar right through the report.
Thanks
Like so:
Click the "extract data" button in the attachment to see the extraction.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Brilliant, exactly what I was looking for, you are a genius.
Thakn you so much, saved me hours!!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks