• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Updating Master Records after checking existing records.

B

Bhawani

Member
Dear All,

I am working on excel file where sheet1 is an input sheet, Sheet3 having existing records and sheet2 is a new master record of employee.

In this user will updated in sheet1 columnA with some values and this value will be cross checked from sheet3, if value found then no action required and if value not found then that value should updated in Sheet2 ColumnA below last entry.

In attached example values a to h from Sheet1 will be checked in sheet3 and as d,e,f,g & h will be updated in sheet2

I have tried with loop but not getting result and now i am stuck, please get me out.
 

Attachments

  • Book1.xlsm
    16.5 KB · Views: 5
Hi !

If headers in real worksheets (?)
so it's an easy unique statement using an advanced filter
without any slower loop !
​
 
You must log in or register to reply here.
Back
Top