Hi,
In my attached file there are two months of data: Previous Month and Current Month.
In current Report sheet- I want COl. O be updated with a lookup value from Col. H in Previous report sheet. Any cell that comes as blank should be updated as Added.
When I run the below mentioned code, my results for Small Switches are coming as 119 whereas it should be 104. Please assist. Below is my code and attached is the dummy file. Please assist at the earliest. Thank you.
Please note- I tried changing the lastrow3 and it worked but then in this case, it takes time to run. Any help?
I changed the last row 3 as:
lastRow3 = sht4.range("a1").End(xlDown).Row
Bookmarks