Autofill block of cells with drop down
 

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.

Autofill block of cells with drop down
 

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

On Feb 5, 11:18*am, Mangesh wrote:
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.