shaunridewood
New Member
- Joined
- Aug 2, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
So have have set up a formula using the filter function which copies data from one workbook to another when certain criteria is met as follows:-
=FILTER('[St Neots - Project Data Sheet.xlsx]Ground Floor'!B3:B57,'[St Neots - Project Data Sheet.xlsx]Ground Floor'!Q3:Q57="Y")
However this still sorts in row order of the original workbook regardless of when the criteria has been met.
So for example y is entered into rows 1, 10 and 12 of the original workbook and it copies this data across to rows 1 - 3 in the new workbook. however if i think go back and enter y into lines 4, 7 and 11 for example, it will copy the data from 4 & 7 to lines 2 & 3 on the new workbook and row 11 will appear between 10 & 12.
Instead i want the data to automatically populate to the next available row rather than match the original order. is there any way of doing this?
=FILTER('[St Neots - Project Data Sheet.xlsx]Ground Floor'!B3:B57,'[St Neots - Project Data Sheet.xlsx]Ground Floor'!Q3:Q57="Y")
However this still sorts in row order of the original workbook regardless of when the criteria has been met.
So for example y is entered into rows 1, 10 and 12 of the original workbook and it copies this data across to rows 1 - 3 in the new workbook. however if i think go back and enter y into lines 4, 7 and 11 for example, it will copy the data from 4 & 7 to lines 2 & 3 on the new workbook and row 11 will appear between 10 & 12.
Instead i want the data to automatically populate to the next available row rather than match the original order. is there any way of doing this?
