Hello all,
I have attached a sheet with a basic example of what I am trying to achieve. I have data on the "Data" sheet which is stored / historical data which I am looking to reference. I have new data for today`s date in sheet "NewData" which I want to compare with the existing historical data. I initially want to just copy the data in Data and paste it below, changing the date to the date in the NewData sheet. This is of course straight forward but once I have it below the historical data, I then want to lookup to see if the data appears in NewData or not. If the result is no, just return a zero but if the result is yes then I need to do a second lookup in sheet vlookup.
My main area where I am struggling is the number of rows changes every day, so I cannot fix that as well as whether to fix a VLOOKUP function in a cell, copy it down, try to install a wait in the code while it updates and then delete the empty rows ?
Any advice on how to tackle this in a streamlined way would be great as I can see this running very slowly if I try it on more than the 20 or so lines in the example attached !
Many thanks
JM
Bookmarks