Forum Discussion
How to move data from one sheet to anoth
I have a large excel sheet full of information on aircrafts. The sheet is separated by hanger and not by dates. I want to use the dates on the planes and separate them by week onto a new sheet so I c...
Let's say the dates are in D2:D1000 on a sheet named Aircraft Data
On another sheet, enter 02/05/2023 in cell A1 and 02/11/2023 in cell B1.
In A3, enter the formula
=FILTER('AirCraft Data'!A2:Z1000, ('Aircraft Data'!D2:D1000>=A1)*('Aircraft Data'!D2:D1000<=B1), "")
HansVogelaar I'll try that as soon as possible and let you know if it works! Thank you!