Forum Discussion

RBA-Matt's avatar
RBA-Matt
Copper Contributor
Jan 27, 2025

Sinlge ddown - full row movement - seperate sheets

Thank you all for your assistance with this. I've spent a lot of hours trying to determine which formula to use I apologize as this seems so simple and I thought I've figured it out multiple times now but no luck.

 

I build custom homes, I want to provide my clients with a spreadsheet to add their selections of finishes, this will allow the designers and coordinators to purchase and organize what is required for each project.

 

Excel 365

My intention is to have sheet 1 ( "Selections" ) as the full list of all finishing selections from the client / Designer. In column C - I have added a drop-down list showing the different types of selections I want to separate this info into. ( Flooring, plumbing, tiles, etc. )

Sheet 2 ("Sorted by Category") will have a ddown list of the same types of finishes found in the dropdown list on Sheet 1

The Goal is to select "Tiles" from the ddown list on sheet 2 and have all rows that include "tiles" in the Category column to populate the table.

 

Example - On sheet 2 - I select "Tiles" from the ddown list - Sheet 2 will then populate all rows from Sheet 1 with "Tiles" in the Category column - also filling out the other information on the same row.

 

On sheet 1 is a table called "Selections" - B9-L100 is the data - filled with the clients requested items. There are additional rows at the bottom for adding items as the project continues that also need to be added to sheet 2 as they are inserted onto Sheet 1 with the proper ddown selection.

  • Cell A8 Panel Freeze

On sheet 2 is a table called "Category" - Same table as Selections but all selection data is removed - Ddown box in Cell G4 - List of ddown box items on Sheet 3 in table called List.

  • Cell A8 Panel Freeze

Sheet 3 is a table called "List"

 

Ive tried Vlookup, Xlookup, match, unique, index and indirect, - at this point, I've watched so many Youtube videos / read so many Reddit/TechCommunity posts I'm now lost as to how to get this to work.

 

Hope this Dropbox link works of the Excel file

https://www.dropbox.com/scl/fi/x9kqwv259n76znoeoga6r/Finish-Schedule-Example.xlsx?rlkey=9df0twzr6jyrsl83li2l5psik&st=hix3qno3&dl=0

Thank you, thank you, thank you!

 

  • 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.

     

     

    • RBA-Matt's avatar
      RBA-Matt
      Copper Contributor

      Steve - You're the FN man!

      Thats exactly what I was looking for.

      Where should I be applying that Function?

      Would that be in the first empty spot on the drop down list sheet where I want to see the items from the previous sheet?

      • Glad that helped.  Yes. The formula with the FILTER function should be at the top-left of where you want to see the data. It will spill the results to the right and down.

Resources