Vlookup & Macro Help!

[Mike Lindsay]

I am seeking help w/ a complex Vlookup formula. I am trying to write a
formula that allows a user to enter a product number in a cell and have the
product description and subsequent price appear in the adjacent 2 cells. The
information would be pulled from a product catalogue in a different tab. I
am very familiar w/ Vlookup, but I need it written in a way that copies not
only the text but the text formatting (color, Italics) and the cell size, to
accommodate the text. I have very little experience writing Macros. Please
help.

 

[Stopher]

I am seeking help w/ a complex Vlookup formula. I am trying to write a
formula that allows a user to enter a product number in a cell and have the
product description and subsequent price appear in the adjacent 2 cells. The
information would be pulled from a product catalogue in a different tab. I
am very familiar w/ Vlookup, but I need it written in a way that copies not
only the text but the text formatting (color, Italics) and the cell size, to
accommodate the text. I have very little experience writing Macros. Please
help.

If you record copy and pasting macro that does what you want you will
have the core of your VBA. Then you need to assign a value or cell
reference to the drop down box, which I guess is indexed from a
catlogue list?

Your macro will have to be stored as on change for each specific
selection drop down, as in each time you change the value from the
dropdown it will go and retrieve new values from your catalogue sheet.

I think this is the easiest way to resolve your problem.

 

[Mike Lindsay]

Stopher,
Thank You for the reply. I should have been more clear. I have no
experience writting macros. Your response, while technical and probably
accurate was foreign to me. Is there any way you could walk me through this
a little more clearly?