J
Jennifer Waterhouse
I've made a fax sheet in excel with a number of blocks to be filled.
Company name, ph#, fax number, part #, etc.
All this information is present on another sheet when I input my order. The
first column on that sheet is my Purchase Order Number (IE : TT4153). The rest of the row contains the product description, Company name, ph#, fax number, part #, etc...
Here is what I would like to be able to do. Input the Purchase Order Number
in a cell on the fax sheet, press enter, and all the blocks on the fax sheet
would fill from the row of that Purchase Order.
Another way to explain it. A formula in the cell for the Company Name on
the fax sheet that would read the Purchase Order Number cell, then find that
row on sheet 2 and take whatever was input in, let's say column 'H'.
Any help would be much appreciated
MIKE
Company name, ph#, fax number, part #, etc.
All this information is present on another sheet when I input my order. The
first column on that sheet is my Purchase Order Number (IE : TT4153). The rest of the row contains the product description, Company name, ph#, fax number, part #, etc...
Here is what I would like to be able to do. Input the Purchase Order Number
in a cell on the fax sheet, press enter, and all the blocks on the fax sheet
would fill from the row of that Purchase Order.
Another way to explain it. A formula in the cell for the Company Name on
the fax sheet that would read the Purchase Order Number cell, then find that
row on sheet 2 and take whatever was input in, let's say column 'H'.
Any help would be much appreciated
MIKE