Hi Alu1201

basically this report will have to do everyday.
the sheet "ClusterB" is what i record macro half way.
And I wan the report to look like sheet "FInal Result"

when u look at the sheet"clusterB", it consist of difference time slot.
I would like the marco to indicate the time slot above the header i/o of repeating it in every row. (eg. sheet"Final Result" B8)
The outcome will be like:-
Time slot 1
No Name HU Remarks Location
1 XX XX XX XX
2 XX XX XX XX

Time slot 2
No Name HU Remarks Location
1 XX XX XX XX
2 XX XX XX XX
3 XX XX XX XX

Hope this is clear