Hi everyone,

I have two sheets in my workbook containing addresses.

i.e.
- Sheet("A") containing addresses from cell E2 downwards.
- Sheet("B") capturing addresses from Sheet("A") from cell A5


How do I capture original address(unique address) from Sheet("A") and
repeat it eight times in Sheet("B") from cell A5 downards and move on
to the next unique address on Sheet("A").

e.g.
If Range("E2:E5") in Sheet("A") are as below:

E2: Brisbane (59)
E3: Brisbane (79)
E4: Perth (20)
E5: Sydney (30)


I want Sheet("B") from A5 to be as below:

A5: Brisbane (59)
A6: Brisbane (59)
A7: Brisbane (59)
A8: Brisbane (59)
A9: Brisbane (59)
A10: Brisbane (59)
A11: Brisbane (59)
A12: Brisbane (59)
A13: Brisbane (79)
A14: Brisbane (79)
A15: Brisbane (79)
A16: Brisbane (79)
A17: Brisbane (79)
A18: Brisbane (79)
A19: Brisbane (79)
A20: Brisbane (79)

and so on...

Thank you for your help in advance.


Regards,


James