Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Updating excel spreadsheet with data from a second spreadsheet?
I have a spreadsheet which I have been manually entering updates to on a monthly basis. These updates come in the form of a second spreadsheet. I have tried using the consolidate function to merge them together (with the hopes of it being smart enough to overwrite old fields). The summary functions available however do not seem to allow a simple overwrite - they insist on creating a sum/product/etc from both values.
Some of the data is text and some is integers. All of the headings are equal and the left column is a unique identifier that would allow a row to match up with another row if there is a way to join them based on that field. Can anyone suggest any options? Thanks!
2 Answers
- Michael ELv 71 decade agoFavorite Answer
I suggest you ask this question at
A useful answer would require more back and forth about your data layout and desired result than Yahoo! Answers is set up for.
- 5 years ago
You will need a macro to open the first spreadsheet, get it to automatically update and then copy the data that you need and return to the second sheet and go to the bottom of your data and paste the new data in a new row. You can do this by using the "Record Macro" feature and then edit the macro to fine tune it.
