Filling in id number that are missing from two spreadsheets

[tantcu]

Hello,

I'm working to insert new data to sheet 2. All the data is available in Sheet 1. I can use Vlookup function for Sheet2 to get value from column B of sheet 1. However, do you know any formula that I can use to find out any id of sheet 2 is missing from sheet 1 and add them to the id column of sheet 2 and add them to the next row of the last row instead.

Attached is the file Sample.xlsx . Please help me on this and thank you in advance.

[niladri2005]

Hi Tantcu,

Please find the attached file. I have taken the help of Macro. In sheet 2 you will get a box. click that box and Not available codes will be added in sheet 2.

[:) Sixthsense :)]

AUTOMATICALLY INSERTING OF DATA not possible in worksheet function so I have given VBA code solution. I have attached your workbook with the below code and in sheet2 I made a button to get the MISSING DATA on click.

Please Login or Register  to view this content.

[tantcu]

The macro is very awesome. Thank you for sharing.