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