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

"Jumbo Jock" wrote in message
...
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