| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Spreadsheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching and Moving Data From One Spreadsheet to Another? | Excel Discussion (Misc queries) | |||
| excel inventory spreadsheet | New Users to Excel | |||
| Copy From One Spreadsheet To Another Spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
| vlookup reverts to data from a previous report | Excel Worksheet Functions | |||
Threaded Mode
