copy cell contents from one sheet to another within a loop

[lundy]

Hello,

I have a loop function that goes through a list of employees and i want to move their name to a different sheet(monday, tuesday...) so that I know who is in on what day. is there a simple way to have it add the next name to the bottom of the list?

thanks,

[nathansav]

Any more details? As your post is written.

worksheets("Sheet1").usedrange.copy destination:="Monday" etc.

You mention a loop, do you want the loop to check if they are in on the days.

[lundy]

here is a part of the code, to make is easier I just want to move certain cells from the main page to a new tab "monday"

Please Login or Register  to view this content.

[lundy]

that works for the first entry but how can I put the next name on the list without losing my place on the current tab.