Autofill block of cells with drop down

M

Mangesh

Hi,
For certain application I want to autofill a block of cells (10 rows and 15
columns)(stored/calculated in another worksheet)
This autofill is selected based on the ID selected by user through a drop
down menu.

Thanks for your help.
 
P

Pete_UK

Generally you can use VLOOKUP to do this, but depending on how your
data is laid out you might need to use an INDEX/MATCH combination.

Pete
 
Top