• 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.

Crazy with macro index &match not working properly after second click in vba editor

RAM72

Member
Hello

I have a database and imput sheet where column A and B are updated from database .

However I am facing an issue that on applying macro it works but when I delete data in column A and B in imput sheet and run macro nothing happens.

But when I copied to a new workbook and reapplied the macro it works and I have the same issues again I does not update .

The formula version is next on imput sheet with N/A

Can someone help as th macro is in sheet 2 column F where amendements have been in red.
In column A is the original but has some bug issues .

I am completely dumbed
 

Attachments

  • index match macro.xlsm
    28.3 KB · Views: 6
Hello NARAYANK991

Ooops workings:):awesome::awesome::awesome::awesome::awesome::awesome::awesome:

Thank you a lot.

Hope other members will benefit from index and match macro.

It so powerful and versatile.

Thank you again for your invaluable assistance.:)
 
Back
Top