Hi folks.
I'm pretty new with excel and not so familiar with the coding yet so I am trying to make an way to filter some data from my dropdown list. Due to the amount of data I have them on multiple different sheets but I want to be able to collect the correct information with the dropdown list. To do that I figured that I could filter with the dropdown list as a target. So the way I did it was to use the dropdown list to grab the name of the sheet as well but it wont read it. So I basically hoped this would work: =FILTER(CONCAT(Data!A4,"Data",Data!B4)!A:T,CONCAT(Data!A4,"Data",Data!B4)!R:R=A4,0) where DataA4 reads the first part of the sheet name from the dropdown list while DataB4 reads the last part so when merged it shows brandDataMarket!A:T. Excel seems to not want to read it when I have grabbed the text from somewhere to use it for the filter. Anyone know the reason for this or have another way of doing it?
Thanks
I'm pretty new with excel and not so familiar with the coding yet so I am trying to make an way to filter some data from my dropdown list. Due to the amount of data I have them on multiple different sheets but I want to be able to collect the correct information with the dropdown list. To do that I figured that I could filter with the dropdown list as a target. So the way I did it was to use the dropdown list to grab the name of the sheet as well but it wont read it. So I basically hoped this would work: =FILTER(CONCAT(Data!A4,"Data",Data!B4)!A:T,CONCAT(Data!A4,"Data",Data!B4)!R:R=A4,0) where DataA4 reads the first part of the sheet name from the dropdown list while DataB4 reads the last part so when merged it shows brandDataMarket!A:T. Excel seems to not want to read it when I have grabbed the text from somewhere to use it for the filter. Anyone know the reason for this or have another way of doing it?
Thanks