| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Updating 1 spreadsheet from another
I have a spreadsheet that contains information on lot number sold, price,
settlement date and who the purchaser is. I have a second spreadsheet that contains lot number, purchaser and settlement date. I would like to be able to set up in the 2nd spreadsheet a formula so that when a new lot number goes into the 1st it updates the second. The second spreadsheet is sorted by Purchaser. I was thinking possibly a comination of VLOOKUP and IF statements but am now completely at a loss as to where to start! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
| Using multiple spreadsheet for different information | Setting up and Configuration of Excel | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) | |||
| Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
Threaded Mode
