Autofill the 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 the block of cells with drop down
 

I couldn't understand your question exactly, but I think Vlookup could solve
your question. Vlookup(A1, B2:D10,2,false)
A1 in your case will be the drop down entry. B2:D10 will be the table in
different worksheet and ID column should be its first column.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"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.

Autofill the block of cells with drop down
 

Hi Khoshravan,
Thanks for the reply.

Actually I'm using Vlookup(), but it helps only to fill one cell,right?
If there are few cells only we can use multiple Vlookup(),

But I'm talking about around 100-120 cells to be auto filled depending on
the selected item.

Ex. If user selects any city from the drop down,
we should be able to autofill cells that shows say,
Temperature,Humidity,Rainfall ect of complete month/week.
i.e 3x30 cells

I wish I'm more clear now.

Hope to see your reply soon.

Thanks.


"Khoshravan" wrote:

I couldn't understand your question exactly, but I think Vlookup could solve
your question. Vlookup(A1, B2:D10,2,false)
A1 in your case will be the drop down entry. B2:D10 will be the table in
different worksheet and ID column should be its first column.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"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.