i created a simple ODBC connection in excel to Oracle. I have the data pull into a table. the table name is Table1 and its on Sheet1. in Sheet1 cell D1 i have the formula =NOW() (date is in format M/DD/YYYY). Sheet2 has a list of days in column A (format is M/DD/YYYY). I want the Macro to look at Sheet1.D1, find that cell in Sheet2 column A and paste the count value in column B.


My dream is to come in every morning, open up the excel document, click refresh and then run the macro. My actual dashboard is a bit more complicated than stated above, but if someone can get me a lead on the above i can figure the rest out myself.

Thanks!