D
DB
Hello,
I am working with order forms for different types of
equipment, each having its own worksheet. After selecting
the appropriate sheet, I then want the information to
appear on a quote form (that doesn't show all of the
technical info behind the scene). I get the quote form to
work, if I have a quote form for each piece of equipment.
Each selection in the worksheet is currently using vlookup
functions to select from a list A5:C15 to give me a part
number, description, etc.
The problem is: My boss only wants ONE quote form...and
for it to know which worksheet to pull the info from. I've
selected cell D2 as the identifier cell(name of each piece
of equipment). How do I get the form to go to the correct
worksheet? Please give me an example, if it's possible,
using the different worksheet names: FIRST, SECOND, THIRD
and the quote form QUOTE.
Any help would be greatly appreciated!
I am working with order forms for different types of
equipment, each having its own worksheet. After selecting
the appropriate sheet, I then want the information to
appear on a quote form (that doesn't show all of the
technical info behind the scene). I get the quote form to
work, if I have a quote form for each piece of equipment.
Each selection in the worksheet is currently using vlookup
functions to select from a list A5:C15 to give me a part
number, description, etc.
The problem is: My boss only wants ONE quote form...and
for it to know which worksheet to pull the info from. I've
selected cell D2 as the identifier cell(name of each piece
of equipment). How do I get the form to go to the correct
worksheet? Please give me an example, if it's possible,
using the different worksheet names: FIRST, SECOND, THIRD
and the quote form QUOTE.
Any help would be greatly appreciated!