Autofill block of cells with drop down

  • Thread starter Thread starter Mangesh
  • Start date Start date
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.
 
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
 
Back
Top