Hi All,
So I'm working with a data sheet containing lots of data and I'm looking to copy across row data based on a defined date range. The range is today - 5.
The data I'm trying to copy across is in Sheet2 and I want to pull out data from a date range in merged cells with the code =TODAY() and =TODAY()-5 which sits in Sheet4.
I've done some investigations but I keep on getting met with the solution to use Kutools to resolve it which I don't want to do as other people will be using this workbook who wont have access to Kutools. I've also tried -
=IF(ROWS(A$5:A5)>$C$2,"",INDEX(Sheet1!A$2:A$22,SMALL(IF((Sheet1!$A$2:$A$22>=$A$2)*(Sheet1!$A$2:$A$22<=$B$2),ROW(Sheet1!A$2:A$22)-ROW(Sheet1!$A$2)+1),ROWS(A$5:A5))))
I took this from
www.extendoffice.com
and changed the values and sheets but it didn't work. I can't figure out why. Would it be because the date range in Sheet4 sits in a merged cell?
If you guys could help me with either a VBA script or a calculation to get this done it would help me out a whole lot.
Many Thanks
So I'm working with a data sheet containing lots of data and I'm looking to copy across row data based on a defined date range. The range is today - 5.
The data I'm trying to copy across is in Sheet2 and I want to pull out data from a date range in merged cells with the code =TODAY() and =TODAY()-5 which sits in Sheet4.
I've done some investigations but I keep on getting met with the solution to use Kutools to resolve it which I don't want to do as other people will be using this workbook who wont have access to Kutools. I've also tried -
=IF(ROWS(A$5:A5)>$C$2,"",INDEX(Sheet1!A$2:A$22,SMALL(IF((Sheet1!$A$2:$A$22>=$A$2)*(Sheet1!$A$2:$A$22<=$B$2),ROW(Sheet1!A$2:A$22)-ROW(Sheet1!$A$2)+1),ROWS(A$5:A5))))
I took this from
How to extract all records between two dates in Excel?
If you guys could help me with either a VBA script or a calculation to get this done it would help me out a whole lot.
Many Thanks
