I have an excel sheet with columns like below:
I have two sql queries that return data, and I need to paste that data into the correct cells according to the date. So if I run the query today, I want it to paste the data into the row for 4/13/2020.
Query 1: results should go in column B & C respectively
Returns: 800, 900
Query 2: results should go in column D & E respectively
Returns: 500, 650
So for today I would want my updated excel to show:
After I output the sql queries to datatables variables, I am lost on what to do…any help would be appreciated!