Hi ,

Pls help with the below VBA query. I have two columns (A & B) in excel



A B
XXXX 111
111
111
YYYY 222
222
222
ZZZZ 333
333
333


I need to write a macro that will copy XXXX until it reaches YYYY, copy

YYYY unit it reaches ZZZZ and so on.

Thank you.