In My dashboard I have two sheets referring to 2 different tables. Sheet1 is cross tab. Each row contains startdatetime & enddatetime. On selection of row from sheet1, need to bring data within that date range on sheet2. On sheet 2 I have datetime column.
So basically I need to show data within datetime>= startdatetime & datetime< enddatetime on second sheet, on selection of row from sheet1. Any help would be greatly appreciated. Thank you in advance.