bclaussen

New Member
Joined
Apr 6, 2011
Messages
3
I am trying to create a dropdown list that when an item is selected in the dropdown, the cells to the right autofill with data related to that selected item. For example. If I click on a dropdown and choose "Wednesday" in Cell A, then in Cell B, C, and D, autofill with "work", "gym", and "errands". If this is possible, could someone guide me on how to do this?
Thanks
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
Hi and Welcome to the Board,

Why not build a table with all your requirements and then utilize a vlookup.

With the lookup value in A1

In B1 =VLOOKUP($A1,$H$1:$K$14,COLUMN(B1),0)

and copy over to the right (C1, D1)
 

bclaussen

New Member
Joined
Apr 6, 2011
Messages
3
I can be a little more specific. I am linking a database to another worksheet and it will have data not only for agendas daily, but my exercises for each day, my meals, etc. So in addition to the initial reply, if I click a dropdown box and I select eggs, I would want it to populate to the right of it, serving size, protein etc. This data would come from the database. I am just trying to organize my days to keep on track. Thanks for your reply.
 

bclaussen

New Member
Joined
Apr 6, 2011
Messages
3
I figured out what you were trying to say. Yes, vlookup does work. How do I link that data from another workbook? I'd like to duplicate the same worksheet referencing data from the same workbook for my wife too. Could I just simply copy the initially created worksheet and paste in a new worksheet? Or do I need to recreate all the formulas in the new worksheet to link to the same database that the initial worksheet is pulling from? Thanks for your help, I appreciate it.
 

jeffreybrown

Well-known Member
Joined
Jul 28, 2004
Messages
5,145
I'm glad you got it all sorted.

Yes you could make a copy of the worksheet into a new workbook/sheet and the links to the workbook with the data should carry forward.

Go to the sheet which you have already built with the links, right click on the sheet tab >> move or copy

In the first drop down >> To Book: Select (new book) or a book you have already created (which needs to be opened already)

Before you select OK check Create a copy.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,911
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top