Hello All,
This forum is amazing for helping people like me work through certain challenges.
I am looking to pull data from multiple sheets based on simply inputting a date range into the reference bar and returning certain data to the table on first sheet.
I am currently using a vlookup in the table to pull from sheets..but how do I make the table return data from the date of the sheet input into the reference cells? In other words make the table dynamic to the dates entered in the date rage reference cells.
Example: Reference Cell(s) Date: November 12 2012 to November 20 2012.
I want the table below reference cells (on same sheet) to return certain cell data from the sheets named "November 12 2012" and "November 20 2012" within same workbook.
Any suggestions or help would be greatly appreciated!!
Bookmarks