I use excel to send out request for quotes to vendors and then transfer that
information into a purchase order. I send out a request for quote to several
vendors for the same products. When vendors return the request I open an
excel spreadsheet and put the prices in each vendors spreadsheet. I've
created a spreadsheet that allows me to put an "x" beside the cheapest price
and an excel formula coppies the description and the price to a different
purchase order spreadsheet. =IF('RFQ Results'!D8="X",'RFQ 1'!D18," ") The
problem arises when I purchase items from the same request for quote from
different vendors. The way the formula is written when I put an "x" beside
line items 1, 4, and 7 on the request for quote they are coppied to lines 1,
4, and 7 on the purchase order instead of lines 1, 2, and 3 on the purchase
order. I need a formula that allows me to select lines 1, 4, and 7 from the
request for quote page and places the itme in lines 1, 2, and 3 of a purchase
order sheet. Does anyone know how? Thanks