I am trying to auto-populate a row based on a provided date range. The data would be pulled from Sheet1. Sheet1 has two rows. Row 1 has numbers in each cell. Row 2 contains a date for each value in row 1. For example, A1 and A2 would be 12763 and 3/22/2019, B1/B2 would be 12653/ 3/22/2019, E1/E2 would be 12760/ 4/5/2019.
Now in Sheet2, if I were to put in 3/18/2019 in I2 and 4/1/2019 in L2 in row 2 the next row would be populated with all numbers in that date range (in this case the first value in the next row (A3) would be 12763, the next (B3) would be 12653 and would exlcude 12760 as it falls outside the date range.).
I cannot figure this out. If macros are needed for this please let me know! I'm sorry if I explained this poorly. I attached a workbook with two examples of the end result.
Thank you.
Bookmarks