Macro to Continue Loop untill empty cell

Hi all,

I'm strugling for a couple of days with following macro. My code should assign controller name from the "People list" to the "Tracker" sheet based on condition if he or she is marked as "In". This works perfect for me. However, once macro is on the end of the people list it's stop working. Or actually is doesn't continue.

So what I basically want to modify it's to continue with macro untill Column I is empty. Is there anybody who could help?

Please Login or Register  to view this content.

Thank youuuuuuuuu,
Andy

Hi TMS

I've tested it but still not working, I've got error that objects does not exist I have no idea how to do this Or is there a way, that once A3, than A13, than A23 etc each 11th row is filled, controler name from the People list will be added automatically according to the criteria in people list?

Thanks a lot for your help,
Andy

Hi TMS,

please apologize. I've uploaded the requested file.

As well, i sthere a way to add criteria that if Agent name is same, to continue with next Contriler form people list?

Thanks a lot for this.
Andy

Hi TMS,

thanks for the update. I was checking your code and worked fine. :-) It copied only those names which are marked as " In". Which is correct, but only once, when macro is in the end of People list column.
Is there a way, that macro could copy those "In" marked names more times, depending on sheet "Tracker", column "A", so untill last active cell? As well I realised, that when I mark more people as " IN", macro will overwrite already assigned names in "Tracker" sheet column "K". So basically, once name is assigned in column K, to not delete it.
I will have 2000 lines in "Tracker" sheet, therefore, if this could be somehow automated, will be fine.

Thank youuuuuu
Andy

Hi,

Is there abybody who coud help me to fix this macro?
😕
Thanks
Andy

Hii


thanks a lot. It works as never
I just wanted to ask, that is it possible to add one small criteria, that once the Agent name is pasted to column K in "Tracker" sheet and is equal to agent name in column A "Tracker" sheet, that macro will skip this name and past the next one?

Thank you a lot
Andy

Hi,

someone to help me with?

Thanks a lot,
Andy

Hi

hmmmm, I don't understand your point. It's Friday already

I know, but might happened, that it assign personn from people list to same person in Tracker sheet.

This is what I was asking, if it's possible

Hi,

when I use that code, it always assugn same user in some cases.

Example Agent 1 to Agent 1 Maybe I'm doing sometihng wrong

Hi,

Yes, im so sorry for not beeing clear. :-(
This tracker should help us when doing quality check. So,example if I mark to Agent 1 that is at work (in) in people sheet and run macro, this should not assign Agent 1 from people list to Agent 1 in Tracker sheet. As this person could not do the quality check on himself. So to have same macro as I have from you, but with condition, that will always assing diferent agents, not the same one.

Sorry if not clear.

Juchuuuuu, works

Thanks a lot you saved my life