Hi Guys and girls,
In September 2014 Richard Buttrey assisted me in solving a similar but less"complicated" problem I had . Thread name "extracting/transposing" sheet data.
I have a new challenge with a more complicated timetable (file "New Timetable" attached)in the attached file with two worksheets Zone 3 to Pta (this is the example of how the timetables look like) and Solution (the format in which I now need it - i only included 3lines as example). The timetables can contain more columns as well as rows.
What is important (and I don't know whether it is possible) I need the name on the tab as part of the solution if possible.
I attach the solution which Richard provided earlier for reference purposes with file name "timetable".
I need to do this for approximately 50 timetables of a similar format.
Your guidance and assistance will be appreciated.
Regards
Danie
Bookmarks