Forum Discussion
Conditional text move row to sheet
Okay. So I formulated this workbook, and of all things I've accomplished with it, this is the one I'm struggling with. I have Information from the Access Database coming in to the "Access Query" tab....
Maybe, the new FILTER-function can be of help:
=FILTER(RoomingList[NAME];IFERROR(SEARCH("Walk";RoomingList[NOTES];1);"")<>"")
If you place this function in cell A5 of the 728 Walk On-sheet it spills the names from the Rooming List-sheet where the NOTES-cell contains "Walk" as supplied by the Access Query-sheet. The outcome looks somethings like this:
Note that you have to unmerge the cells A5 till B29, otherwise the FILTER-function can't spill the result. You can use the same formula-structure for Branch and Room number.
I hope this puts you in the right direction. And for your convenience I attached a modified version of your workbook.
That worked fantastically!