View Single Post
 
Old 02-16-2015, 01:56 PM
markharper80 markharper80 is offline Windows 8 Office 2010 32bit
Novice
 
Join Date: Feb 2015
Posts: 3
markharper80 is on a distinguished road
Default Selection from cell with list contents autopopulates contents of another cell

Good day all,
This is my first post so let me start by saying thank you in advance. I will do my best to make sense describing the challenge I am facing in Excel...

I am creating a grocery shopping planner for our office. I have sheet 1, cell a1 as a list type (which i have done through the data validation > list )and the data in that list are meals (hot dogs, sandwiches, etc). The list items referenced in sheet 1, a1 are on sheet 2 cells b2 through b10. (so sheet 2, b2 would be hot dogs, b3 would be sandwiches and so forth). In sheet 2 column C, I will list the ingredients. So if sheet 2, b2 is hot dog, then sheet 2 C3 would be 'buns, franks, etc' .

What I would like to have happen is when the user selects a meal in sheet 1 from the list in A1 (which is pulled from sheet 2 , items b2-b10), then the ingredients list (sheet 2 c2-c10) that corresponds to items b2-b10 in sheet 2 will populate to another column on sheet 1.

So user selects a meal from the list and the ingredients populate for them somewhere else on the page. Its been a while since I have utilized excel at legth so I am a bit rusty here. Any help is appreciated. Thanks!
Reply With Quote