Want to Filter data on Sheet 2 Column B based on matching drop down selection on Sheet 1 A1
Sheet 1 A1 contains drop down list (text)
Sheet 2 Column B contains text
Want to Filter data on Sheet 2 Column B based on matching drop down selection on Sheet 1 A1
Sheet 1 A1 contains drop down list (text)
Sheet 2 Column B contains text
I'm not real clear what you want, nor what your data looks like. The answers to a few questions might get us both on the same path
- Can you describe your data better than you have, and what your drop down list looks like.
- Can you describe what your end result would look like.
- Can you give a brief "why" you want the results you want.
Sheet1 cell A1 contains a drop down list of "Round", "Oval", "Square" & "Flat"
Sheet2 columnA contains various part #'s. ColumnB contains either "Round", "Oval", "Square" or "Flat".
I'm looking to filter sheet2, based on the drop down selection of Sheet1 cell A1.
I also plan on using formula for other scenarios.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks