| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill the block of cells with drop down | Excel Discussion (Misc queries) | |||
| Drop down lists and autofill | Excel Discussion (Misc queries) | |||
| Help with drop down name to autofill address | Excel Discussion (Misc queries) | |||
| Drop Down List Autofill | Excel Worksheet Functions | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Linear Mode
