Macro to find formula Error and add names to another tab

[dave1983]

What I require is a macro to search a populated column (A:A) in database for #N/A Error and when it finds that error I want the cell to the right to be copied to another tab on the spreadsheet. so to show you what I mean

In cell A1 I have a Vlookup formula referenced to another tab, I have several macros set up to pull information in from other reports and collate them into this one report, when the data is pulled into this report names are populated in cell B1:Bx, When new names that don’t appear in my Vlookup table are entered I get the #N/A error In the formula in column A, what we do as is the standard procedure is to add the new name that has been entered to the Vlookup table on the other tab and then in my Raw Data tab the name of their manager then appears in Column A (as per screen shot)

untitled1.JPG

I am looking for a macro that will find the #N/A error in the Raw Data tab and then add the name that has been generated in column B to my other tab with the Vlookup data (tab name Agent-Manager), I need these names to be added to the bottom of the current list.

If possible I would also like a message box to come up showing the people that don’t appear on the report that will be added to the other tab and give the user a Yes/No option.

Any help would be greatly appreciated.