Vlookup & Macro Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Lindsay - 18 Sep 2006 18:58 GMT

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.

Reply to this Message

Stopher - 19 Sep 2006 06:56 GMT

> 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
[quoted text clipped - 4 lines]
> 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.

Reply to this Message

Mike Lindsay - 19 Sep 2006 13:20 GMT

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?

> > 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
[quoted text clipped - 15 lines]
>
> I think this is the easiest way to resolve your problem.

Reply to this Message