I have a spreadsheet that contains a bunch of dates with several rows of data beneath the cells containing the dates (new dates & data are appended to the spreadsheet on a weekly basis)
In another spreadsheet I have 7 columns containing the dates of the last 7 days (including the current day). This date information is acquired using "=TODAY()".
How can I search the data spreadsheet (first screenshot) for cells matching the dates in the date spreadsheet and then copy the 10 cells below the matching date cell to the corresponding cells in the date spreadsheet? The end result would be something similar to the following:
The dates spreadsheet would update dynamically, so for instance when the current date changes the data in the dates spreadsheet would update to match the new selection of dates.