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