if vlookup returns #n/a then create separate sheet with VBA macro code

Hi,

I need some code in macros vba where when we do vlookup, it returns #N/A then create separate sheet in .xlsm file for these N/A values.

Not a lot of information there.

Perhaps it would be helpful if you could attach a sample workbook and explain the requirement in a little more detail.

BSB

Hi,

I have found solution to my above problem.