Good Evening
I am still trying to learn from provided examples and by searching online but I still have a long way to go.
I have attached a copy of my spread sheet
My desired code would be to be able to either:
1. select an individual from my data list i have (Cell B1) and then search In the whole of the 'Log In % By Agent' tab for the word Under and when it matches the selected name and the word Under it will return result, if there are lots of results then I would like the log in % in D2 down and the date it occured in Cell E2 down.
2. If the search cell B1 is blank then I would like to do a blanket search of the of the 'Log In % By Agent' tab and return every single result for everyone that has under against there log in %, For this search I would also like the persons name to appear in cell C2 down as well as all the other data in D2 & E2 previously.
I dont know if it is possible to group the results by name if there are lots of results?
I know this might be a big ask but if this is achievable please can some one help it would be greatley appreciated.
If there is any more info needed or I havent explained myself clearly just ask.
Dave
Bookmarks