I am a novice in macros.
I only know how to record a macro and use 'relative referencing'
I have written the macro and I can reach a stage where it does the job and highlights the area (cannot get the formatting, but I can live with it).
I have attached the file.
I am getting stuck in copying the data to the adjacent sheet 'xxx'.
I would be grateful for your help.
Thank you,
Bookmarks