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
 

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
Formula autofill to cells below – formula arguments are cell areas in different columns 1
want to autofill from 300+ names 3
Drop down lists and autofill 3
Excel - how to autofill thousands of cells quickly 4
Select drop down menu option using libre-calc macro 0
autofill using mouse is not working in excel 2001 4

Top