Sheet1 I have a bunch of dates back to 2021 with FX rates for some different currencies vs. budget rate. One the second sheet "Web Data" there is a connection to a web page that pulls in updated FX rates but only holds 5 dates. I have the dates and the currencies formatted in "Web Data" from the table
range A29:A33 for the updated dates
range B29:B33 for USD
range C29:C33 for GBP
range D29:D33 for Euro
I can't figure out how to add dates and FX rates in my Sheet1 from Web Data sheet if the date does not appear in sheet1. for example last update was Sept 1, 2022 but in Web Data sheet there is a new FX rate for Sept 2nd in row 33 (row 29 to 32 data has been updated already) and I want VBA to realize there is no Sept 2nd on sheet1 and then update sheet1 with the new data.
Thanks for the help