Link Combo box
 

I want to compare budget data in a workbook from 2 different worksheets
within the workbook.
Example; Compare 'Current month' to 'Budget Year'.
I created a Combo List, but I don't know how to link it to the cells below.
When I use the drop down, I need the info to input (from Sheet1) into the
cells below. Help!

Link Combo box
 

Could you give a simplified example of your problem so I can recreate
it and try to solve it?

My guess is each sheet is a different month or year, and you want one
sheet to compare the two, i.e. show both data side by side on one
sheet, only not sure how to list them? This seems like a VBA problem,
but not sure....

A good read on combo/link lists is here (yay for searching the
archives).

http://www.contextures.com/xlDataVal02.html

Since, NP


On 7¤ë8¤é, ¤È«e9:34, Dimplesgray
wrote:
I want to compare budget data in a workbook from 2 different worksheets
within the workbook.
Example; Compare 'Current month' to 'Budget Year'.
I created a Combo List, but I don't know how to link it to the cells below.
When I use the drop down, I need the info to input (from Sheet1) into the
cells below. Help!

Link Combo box
 

Example;

Sheet1 Sheet 2
May $
Inventory $$$ May $$
Supplies $$$ June $$

I want to create a list of Months (sheet1). Then when I pull down a
particular Month the dollar amount for that particular item (Inventory,
Supplies) will be placed in the designated cell. I can send you a sample
spreadsheet..

"pallaver" wrote:

Could you give a simplified example of your problem so I can recreate
it and try to solve it?

My guess is each sheet is a different month or year, and you want one
sheet to compare the two, i.e. show both data side by side on one
sheet, only not sure how to list them? This seems like a VBA problem,
but not sure....

A good read on combo/link lists is here (yay for searching the
archives).

http://www.contextures.com/xlDataVal02.html

Since, NP


On 7月8日, ��9:34, Dimplesgray
wrote:
I want to compare budget data in a workbook from 2 different worksheets
within the workbook.
Example; Compare 'Current month' to 'Budget Year'.
I created a Combo List, but I don't know how to link it to the cells below.
When I use the drop down, I need the info to input (from Sheet1) into the
cells below. Help!