Hey everyone, Help would be very much appreciated!
I'm using excel 2003 and I want to be able to pull information from multiple spreadsheets (tabs within the same workbook) based on the date. I've posted a picture of one of the workbook tabs below.
I want to be able to pull the activity name (example:A3) and the Due date (example:G3) and have it place them on another excel sheet (an overview one). But to make this trickier I'd want to do this for multiple sheets (tabs) and for it to only pick up "Due Dates" that are 1 month from today's date. So Today is July 25th, I'd want it to search all the sheets and autopopulate all the due dates that it finds that are from July 25-Aug 25.
Is there anyways to do this? Any help would certainly be appreciated!
I'm using excel 2003 and I want to be able to pull information from multiple spreadsheets (tabs within the same workbook) based on the date. I've posted a picture of one of the workbook tabs below.
I want to be able to pull the activity name (example:A3) and the Due date (example:G3) and have it place them on another excel sheet (an overview one). But to make this trickier I'd want to do this for multiple sheets (tabs) and for it to only pick up "Due Dates" that are 1 month from today's date. So Today is July 25th, I'd want it to search all the sheets and autopopulate all the due dates that it finds that are from July 25-Aug 25.
Is there anyways to do this? Any help would certainly be appreciated!
