auto fill cells with "formulas" from within the same worksheet

[Guest]

Hello all

I'm trying to have Excel auto fill adjacent cells in a row (B1:E1) after selecting a name from an in-cell dropdown list at A1. The source of the names in the list (A10:A13) and their corresponding "formulas" are at B10:E10, B11:E11, B12:E12, & B13:E13. Does anyone know how to write a macro or if-then statement, etc. that will automatically copy & paste special (formulas) to B1:E1 upon the selection of the name at A1

Thanks,

btk

 

[DDM]

btk, here's one way. Put this in B1:
=VLOOKUP($A$1,$A$10:$E$13,COLUMN(),FALSE) and copy it to C1:E1.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com

Hello all,

I'm trying to have Excel auto fill adjacent cells in a row (B1:E1) after

selecting a name from an in-cell dropdown list at A1. The source of the
names in the list (A10:A13) and their corresponding "formulas" are at
B10:E10, B11:E11, B12:E12, & B13:E13. Does anyone know how to write a macro
or if-then statement, etc. that will automatically copy & paste special
(formulas) to B1:E1 upon the selection of the name at A1.

 

[Guest]

Thanks DDM. I appreciate your quick response

Your suggestion does result in the corresponding "values" appearing in cells B1:E1. However, the "formulas" that appear at B1:E1 are the VLOOKUP formulas you had me copy vs. the "formulas" located at B10:E10, B11:E11, etc. that I'm trying to get to appear in cells B1:E1

It looks like you're close... I would appreciate a reply if you can think of a workaround

Thanks,

btk