J
Jim
First of all, I have to tell everyone who responds to post how WONDERFUL this
is. I've gotten a LOT of information from you smarties.
I have a workbook with several tabs. One tab has a series of tables for
ordering merchandise by size (lengths across the top, in columns, widths
within the rows). The grid within the column/row headers allows me to enter
quantities by size (length and width). Each of the tables has it's own ID
(not using the NAME function, just from typing in an ID).
What I want to do on the second worksheet is be able to enter that ID and
have the ordered units automatically populated.
I'm assuming it's a VLOOKUP or HLOOKUP but not positive. If this is too
vague, I apologize.
is. I've gotten a LOT of information from you smarties.
I have a workbook with several tabs. One tab has a series of tables for
ordering merchandise by size (lengths across the top, in columns, widths
within the rows). The grid within the column/row headers allows me to enter
quantities by size (length and width). Each of the tables has it's own ID
(not using the NAME function, just from typing in an ID).
What I want to do on the second worksheet is be able to enter that ID and
have the ordered units automatically populated.
I'm assuming it's a VLOOKUP or HLOOKUP but not positive. If this is too
vague, I apologize.