Hi all,
I think this might be a brain buster. Its very manual for me to do this and I hope of the experts on here can help.
See sample workbook attached and what I am trying to achieve is in the "NEW DATA" tab.
You can see the main changes are in the presentation.
From column O onwards of original data the macro has to look down the column and at the first non-blank cell, copy row the new data page under the heading which corresponds with that column. So every column heading will be presented vertically now on NEW DATA page. Then each row where there is a number in that column will then be copied to NEWDATA under the vertical heading.
Not sure I am explaining it well. You will see from the data whats changing in the new data page.
Thanks for your help in advance.
Bookmarks