I used this simple formula to filter data, and it is working perfectly.
=FILTER(Data!A:H,ISNUMBER(SEARCH("Outstanding",Data!G:G)))
I have several buttons – Customer / Date / Outstanding etc. I would like it so that when the user clicks on the appropriate button it shows the filtered data. I used the above formula in the code shown below.
Range("B18").Value = "=FILTER(Data!A:H,ISNUMBER(SEARCH(""Outstanding"",Data!G:G)))"
The problem I am having is that when the button is pushed the formula is returning with the @ symbol at the front which means I don't get the full results showing up, just the first cell. As soon as I delete the @ from the formula bar it works properly.
=@FILTER(Data!A:H,ISNUMBER(SEARCH("Outstanding",Data!G:G)))
I have obviously done something wrong or am missing something in my code and I would very much appreciate some help in fixing this issue.