Hello Excel GuRu's,
I was wondering if this is possible....I would like to add some VBA code that will change the date values I have in my data connection.
I.E. I have the following Data Connection:
Data Connection.PNG
Since this is for a metrics reports, which requires me to pull same data from different date ranges, I would like to be able to have a macro that will prompt me to enter in the values I have highlighted in the image.
I know I can do this by using SQL in VBA itself and pull a record set, however if this way is possible, I would like to attempt this first.
Thank You
Bookmarks