Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2015, 01:49 AM
cfreezy cfreezy is offline How to create a data validation based on another cell's value?? Mac OS X How to create a data validation based on another cell's value?? Office for Mac 2011
Novice
How to create a data validation based on another cell's value??
 
Join Date: Jun 2015
Posts: 1
cfreezy is on a distinguished road
Default How to create a data validation based on another cell's value??

Hey everyone,



I am building a template that consists of only 3 tabs.

One is the raw data tab, titled: Data
One is the list of products I have that feeds the Brand Input tab, titled: Primary Products
One is where I need help (marked in red), titled: Brand Input

I made a comment in the spreadsheet of what I am trying to do. Essentially, if you are in the "selection" column on the "Brand Input" tab, the user should see a list of all bathroom sinks from the data tab for example.

I am going to continue to update the data tab with additional bathroom sinks (example) and I am trying to find a way to quickly update the list once I add more information.

Is it as simple as using a Pivot Table and then just keep refreshing the data? How do I get them in a list format in a pivot table?

Longing for some help...

Thanks a lot.
Attached Files
File Type: xlsm Capex Selection Tool 07.06.15 CF.xlsm (213.8 KB, 3 views)
Reply With Quote
  #2  
Old 06-18-2015, 09:51 AM
Catalin.B Catalin.B is offline How to create a data validation based on another cell's value?? Windows Vista How to create a data validation based on another cell's value?? Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Hi, cfreezy,
Welcome to the forum

You can set a pivot table with Product and description only, both fields in Row field of the pivot table; the most important setting is to set the report layout to be displayed in tabular form, and to repeat row labels.
Then, you can use this relatively simple offset formula:
=OFFSET(Sheet1!$B$1,MATCH(B12,Sheet1!A:A,0)-1,0,COUNTIF(Sheet1!A:A,B12))
You can add data to the data table, when you refresh the pivot table, the new products will show in the dropdowns.
See the file attached.
Cheers,
Catalin
Attached Files
File Type: xlsm Copy of Capex Selection Tool 07.06.15 CF.xlsm (232.9 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a data validation based on another cell's value?? Restrict data validation based upon a cell value Strategic Excel 2 01-27-2015 02:13 AM
How to create a data validation based on another cell's value?? data validation from another sheet paulys Excel 1 06-30-2014 01:40 AM
How to create a data validation based on another cell's value?? Excel 2007, highlight entire row based on data found in one cell MSofficeBLUE Excel 2 10-15-2013 09:51 PM
How to create a data validation based on another cell's value?? Creating formula based on if data is correct in cell MattMurdock Excel 1 08-06-2012 03:11 AM
Data validation with IF Klyxrastafari Excel 1 10-03-2011 04:41 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft