Hi I want to pull data from various spreadsheets but only for the current
date. For example I have a numerous spreadsheets that contains data for 4/1,
4/2, 4/3...etc. This data is inputted daily for each date. There is
specific data that I would like to pull from the most current date and so on
into the future only getting data from the current date. I want to run a
macro that pulls data from the most current date of each excel spreadsheet or
automate the excel spreadsheet to pull from the most current date. Is this
at all possible?