Re: Search specific name and copy a cell from an non-adjacent/unorganized worksheet
Hi AlanSidman,
The VBA looks like it is searching by the color code: I purposely highlighted in red to show you that is the number i wanted from the data. Apologize for the confusion.
what i am trying to achieve here
Searching by agent id (example 8113499) and pull the number below Percent in Adherence
For agent 8113499's percent in adherence should paste into another work sheet beside 8113499 = 21.48%.
I have agents
8113499, 16914, 905, 818000, 818001
I am looking for their percent in adherence in other work sheet.
Keep in mind that the agents position can change depending on their attendance, so the order of agent isn't the same all the time.
Thank you