I don't know if this is possible or not. I am trying to build a
spreadsheet that has 2 pages. On sheet 1 there is an entry blank for a
serial number (B3), and and entry blank for a receipt # (C3). On Sheet
2 is a listing of serial numbers and blanks for receipt #'s. I have
built a formula that will apply the receipt number to the correct
serial number when entered on sheet 1, but whenever it is changed on
sheet 1 it removes the receipt number on sheet 2. What type of formula
could be used (if there is one) to type in entries on one page and have
them match results and leave the receipt number on the second page?????
Please help


--
creese
------------------------------------------------------------------------
creese's Profile: http://www.excelforum.com/member.php...o&userid=35508
View this thread: http://www.excelforum.com/showthread...hreadid=552802