Forum Discussion
Sinlge ddown - full row movement - seperate sheets
The Dropbox link didn't work for me, but I think I am following what you want to do. I think you want to be able to pick an item in a drop-down list on Sheet2 and have it show all the rows from Sheeet1 that match the selection in the drop-down.
I think the FILTER function is the easiest way for you to do that, as in this example. In this case, I have everything on one sheet. If you pick Tiles from the drop-down in G1, it will show all the rows from the table that have Tiles in the Category column. If you need to sort, you can put a SORT function around the FILTER function, such as =SORT(FILTER(Table1,Table1[Category]=G1),3) if you wanted to sort by the Floor column (3).
I hope that helps. If I'm misunderstanding what you're trying to do, please clarify.
The Dropbox link didn't work for me, but I think I am following what you want to do. I think you want to be able to pick an item in a drop-down list on Sheet2 and have it show all the rows from Sheeet1 that match the selection in the drop-down.
I think the FILTER function is the easiest way for you to do that, as in this example. In this case, I have everything on one sheet. If you pick Tiles from the drop-down in G1, it will show all the rows from the table that have Tiles in the Category column. If you need to sort, you can put a SORT function around the FILTER function, such as =SORT(FILTER(Table1,Table1[Category]=G1),3) if you wanted to sort by the Floor column (3).
I hope that helps. If I'm misunderstanding what you're trying to do, please clarify.