Hi folks,
Need a spot of expert help!
I have a workbook containing several worksheets. On the first worksheet in
cell D3, I have a drop down menu containing country names. Depending on which
country is selected, I would like data to automatically populate in column B
of this worksheet starting at B17. The problem is that the each country's
data is on a separate worksheet and does not necessarily start at the same
cell reference on each worksheet. I have tried with nested IF statements and
the INDIRECT formula but I am getting nowhere. Any ideas on a smart way to
get this done?
Thanks

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Jumbo Jock" <(E-Mail Removed)> wrote in message
newsCC31787-499C-4D99-951B-(E-Mail Removed)...
> Hi folks,
> Need a spot of expert help!
> I have a workbook containing several worksheets. On the first worksheet in
> cell D3, I have a drop down menu containing country names. Depending on
> which
> country is selected, I would like data to automatically populate in column
> B
> of this worksheet starting at B17. The problem is that the each country's
> data is on a separate worksheet and does not necessarily start at the same
> cell reference on each worksheet. I have tried with nested IF statements
> and
> the INDIRECT formula but I am getting nowhere. Any ideas on a smart way to
> get this done?
> Thanks

take a look at indirect validation :
http://www.xl-expert.com/IndirectValidation.htm

this uses a dropdown list - each item of the list is actually a named range,
eg Country
the second validation uses =INDIRECT() pointing at the selected item. In
this case, Country would return the countries in that table.

This question has been asked a number of times in the past month - so a
search would be useful to you.

"Jumbo Jock" <(E-Mail Removed)> wrote in message
newsCC31787-499C-4D99-951B-(E-Mail Removed)...
> Hi folks,
> Need a spot of expert help!
> I have a workbook containing several worksheets. On the first worksheet in
> cell D3, I have a drop down menu containing country names. Depending on
> which
> country is selected, I would like data to automatically populate in column
> B
> of this worksheet starting at B17. The problem is that the each country's
> data is on a separate worksheet and does not necessarily start at the same
> cell reference on each worksheet. I have tried with nested IF statements
> and
> the INDIRECT formula but I am getting nowhere. Any ideas on a smart way to
> get this done?
> Thanks