HI,
I modified this to what I think you want.
In this copy you "MUST" format all of the sheet with the "Header" in row 1.
Otherwise the code will not work.
This is not fully tested.
Printable View
HI,
I modified this to what I think you want.
In this copy you "MUST" format all of the sheet with the "Header" in row 1.
Otherwise the code will not work.
This is not fully tested.
Thank you very much, works perfectly!