Linked Spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-3014686%22%20slang%3D%22en-US%22%3ELinked%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20different%20spreadsheets%20in%20which%20both%20have%20similar%20information.%26nbsp%3B%20One%20sheet%20has%20old%20information%20and%20the%20other%20has%20newer%20information.%26nbsp%3B%20How%20can%20I%20take%20the%20sheet%20that%20has%20the%20newest%20information%20and%20overwrite%20the%20sheet%20that%20has%20old%20information%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3014686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3015545%22%20slang%3D%22en-US%22%3ERe%3A%20Linked%20Spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3015545%22%20slang%3D%22en-US%22%3EThe%20'best'%20method%20may%20depend%20on%20a%20few%20things%20like%20if%20you%20have%20other%20cells%2Fsheets%20that%20have%20formulas%20pointing%20to%20that%20original%20data%20and%20such.%20A%20few%20methods%20include%3A%3CBR%20%2F%3Ea)%20delete%20old%20sheet%20and%20rename%20new%20sheet%20with%20original%20sheet%20name%20(note%20this%20will%20break%20links%2Fformulas%20but%20is%20quick%20and%20easy)%3CBR%20%2F%3Eb)%20on%20correct%20sheet%20select%20all%20and%20copy%20(or%20cut)%2C%20then%20paste%20onto%20original%20sheet.%20There%20IS%20a%20difference%20between%20copy-paste%20and%20cut-paste.%20If%20you%20copy-paste%20any%20formula%20will%20update%20based%20on%20the%20relative%20change%20but%20a%20cut-paste%20will%20be%20treated%20as%20a%20move%20and%20try%20to%20keep%20any%20and%20all%20links%2Freferences%20the%20same.%3CBR%20%2F%3Ec)%20similar%20to%20b%20above%20you%20can%20use%20copy%2Fcut%20but%20choose%20to%20paste%20SPECIAL%20(go%20to%20home%20and%20use%20the%20down%20arrow%20under%20the%20paste%20icon%20or%20hit%20ctrl-alt-v).%20Then%20you%20have%20options%20like%20paste%20values%20only%2C%20paste%20format%20only%2C%20or%20many%20other%20options.%20So%20again%20depending%20on%20what%20you%20need%20or%20trying%20to%20achieve%20those%20option%20may%20help.%3C%2FLINGO-BODY%3E
Occasional Visitor

I have two different spreadsheets in which both have similar information.  One sheet has old information and the other has newer information.  How can I take the sheet that has the newest information and overwrite the sheet that has old information?  

1 Reply
The 'best' method may depend on a few things like if you have other cells/sheets that have formulas pointing to that original data and such. A few methods include:
a) delete old sheet and rename new sheet with original sheet name (note this will break links/formulas but is quick and easy)
b) on correct sheet select all and copy (or cut), then paste onto original sheet. There IS a difference between copy-paste and cut-paste. If you copy-paste any formula will update based on the relative change but a cut-paste will be treated as a move and try to keep any and all links/references the same.
c) similar to b above you can use copy/cut but choose to paste SPECIAL (go to home and use the down arrow under the paste icon or hit ctrl-alt-v). Then you have options like paste values only, paste format only, or many other options. So again depending on what you need or trying to achieve those option may help.