Greetings,

I have a spreadsheet with a tab called Clerk. It has names listed under column A. I can’t use A2:A5 because the list could grow. I need all the names pasted and filled down on another tab in the same workbook called Sheet3 in column P.

I need column P below to have the names fill down in order until the last row recorded on column A in that spreadsheet. For example: Jane, Jon, Doe, John, Jane, Jon, Doe etc. until it reaches the end of Sheet3.

Can anyone help me with this VBA macro?

Thank you!

​Greetings,I have a spreadsheet with a tab called Clerk. It has names listed under column A. I can’t use A2:A5 because the list could grow. I need all the names pasted and filled down on another tab in the same workbook called Sheet3 in column P.I need column P below to have the names fill down in order until the last row recorded on column A in that spreadsheet. For example: Jane, Jon, Doe, John, Jane, Jon, Doe etc. until it reaches the end of Sheet3.Can anyone help me with this VBA macro?Thank you!   Read More

​