Copying Data to Different Spreadsheet Using the IF Formula to Filter

[sarawho]

Hello,

I'm trying to split data by one column's variables in a table into an existing worksheet using only formulas so that it will work in Teams and happen automatically.

That way I can share the spreadsheet on Teams and have it work.

I found this formula: =FILTER(ALL_CAMPAIGNS!F:Y,ISNUMBER(SEARCH("SLF",ALL_CAMPAIGNS!F2:F4000)),"No results")


I was hoping I could use it to search my original spreadsheet(ALL_CAMPAIGNS)and copy over all of the contents on the original
spreadsheet that was in columns F through Y. However, the only content I want copied over must contain the text fragment SLF.

When I try to make this a dynamic array I just keep getting the #VALUE! response in my cells.

If it's possible I also want to keep my drop downs in the Split worksheets just in case someone wants to go back to the document and change their answer. Is this possible?


If so, what are some resources I can use/key words I should Google to find this information, or what should be my next steps?

Any help would be extremely appreciated.

Thank you!