Macro to find cells with #N/A errors and add cell opposite to end of list on other tabs

Good Afternoon

I have an Excel sheet that I have set up and is used every day, I have it doing everything that is needed via several different macros.

What I would like to add though is.... Every day a list of stats is generated on employees in the company about all there stats from the previous day, Some days random people from other departments or old user names (used to test things) may come up on the report and I get a #N/A error in my Vlookup formula as they are not in there.

Currently what we do is find the names that need to be added and add them to the lists on the different tabs and then this allows the Vlookup to match the correct information.

What I am trying to do is to search for the #N/A errors in the Raw Data tab and if it finds them to select the name to the right of the error and add that name to the bottom of each list on the different tabs automatically rather than having to add them each time manually.

I have a code that works to find the #N/A errors but, it brings up a Msg box but I can’t get the next bit right.

Please Login or Register  to view this content.

Any help would be appreciated, I have attached the spreadsheet if you need anything else clarifying just let me know.