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