How to sync data between two Microsoft Excel worksheets

1149570 pts.
Tags:
Microsoft Excel
In my department, I'm resonsible for keeping our Microsoft Excel worksheet up-to-date for tracking reasons. Now, a co-worker from another department wants me to fill in his Excel sheet with all of the same information. Would I be able to sync my data over to his sheet? I don't want to maintain two different sheets with the same data.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You might be able to write macro to do the job if both spreadsheets are in one directory. If they are stored on 2 separate computers then that is another story. Are they only looking to have part of the data kept in sync? Sounds like they are passing it on to you because they don’t want to be bothered updating their own version of the same data. Another option would be to give them access to whatever import / code procedure creates your data if that is the case.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Assuming you asked for sync of both workbooks. First open the both workbooks. Select the source one and highlight each cell that you wanted destination/target spreadsheet to link. Right click the selected cell & choose copy then switch to the target spreadsheet. Again select the cell where the source data should be populated. Again right click the target cell and point to paste special then press N (keyboard) to establish a link.
    140,720 pointsBadges:
    report
  • ToddN2000
    If that co-worker is not changing anything it might be easier to move the file to a shared drive/folder and give them read-only access to the file.
    134,635 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: