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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill the block of cells with drop down 2
Autofill list 2
Autofill column values in formulas 4
Drop Down choice needs to lead to another drop down menu 1
HELP!!! I need macro to autofill 4
Formula autofill to cells below – formula arguments are cell areas in different columns 1
AutoFill double click does not work in Excel 2007 3
want to autofill from 300+ names 3

Back
Top