All,
I am trying to create a macro which creates a list on a seperate worksheet.
The data i have is arranged in different cells in "Sheet 1" but predominantly looks like:
<tbody>
</tbody>
What i am hoping to achieve is a list in the following format but in a different spreadsheet:
<tbody>
</tbody>
The list can be generated at any point so i think the start of the macro needs to reset the list produced.
Any help is appreciated.
Regards,
Gurnek.
I am trying to create a macro which creates a list on a seperate worksheet.
The data i have is arranged in different cells in "Sheet 1" but predominantly looks like:
Room | No. |
Lecture Rooms | 12 |
Seminar Rooms | 3 |
Dining Hall | 2 |
Sports Hall | 2 |
Activity Rooms | 4 |
<tbody>
</tbody>
What i am hoping to achieve is a list in the following format but in a different spreadsheet:
Lecture Rooms | 1 |
Lecture Rooms | 2 |
Lecture Rooms | 3 |
Lecture Rooms | 4 |
Lecture Rooms | 5 |
Lecture Rooms | 6 |
Lecture Rooms | 7 |
Lecture Rooms | 8 |
Lecture Rooms | 9 |
Lecture Rooms | 10 |
Lecture Rooms | 11 |
Lecture Rooms | 12 |
Seminar Rooms | 1 |
Seminar Rooms | 2 |
Seminar Rooms | 3 |
Dining Hall | 1 |
Dining Hall | 2 |
Sports Hall | 1 |
Sports Hall | 2 |
Activity Rooms | 1 |
Activity Rooms | 2 |
Activity Rooms | 3 |
Activity Rooms | 4 |
<tbody>
</tbody>
The list can be generated at any point so i think the start of the macro needs to reset the list produced.
Any help is appreciated.
Regards,
Gurnek.