Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate a column of data with a formula using a drop down list
I have several users that do not know how to use Excel and need to change
formulas in a single column to obtain correct data for their needs. I don't want to issue unique files to each user, so I was hoping there is a way to allow each user to select their specific formula from a drop down list and have it populate the whole column of data. Anyone know how or if this is possible? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate a column of data with a formula using a drop down list
I have a slightly different idea. Creatte a drop down box with the peoples
names. when this cell is changed, run a macro that fills a formula into the column. Since formulas are string in VBA Range("G7").FormulaR1C1 = "=R1C1" You can have Select Case Range("A1").value Case "John" Range("C1:C15").FormulaR1C1 = "=5 * R2C1" Case "Dave" Range("C1:C15").FormulaR1C1 = "=6 * R2C1" Case "Mary" Range("C1:C15").FormulaR1C1 = "=7 * R2C1" end select "nafflerbach" wrote: I have several users that do not know how to use Excel and need to change formulas in a single column to obtain correct data for their needs. I don't want to issue unique files to each user, so I was hoping there is a way to allow each user to select their specific formula from a drop down list and have it populate the whole column of data. Anyone know how or if this is possible? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a drop-down list along with an auto-populate drop-down | Excel Discussion (Misc queries) | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
When I select from drop down menu I would like the next column to populate a specific cost. | Excel Worksheet Functions | |||
populate data valadation list by criteria | Excel Worksheet Functions | |||
Populate Drop Down List | Excel Worksheet Functions |