Sync different workbooks

[Kyrre]

Can someone please help me with my issue before I'm going nuts

I have 6 employies that have their own workbook shared with onedrum.com and me.

I have a workbook that shall get their workhours synched with my workbook, and at the same time synch back to their workbook.

This is beacuse they work at different projects, have different salary etc.

And I will save a lot of time if the employies can have their workhours updated at all time, and at all time have what the salary is updated from my workbook.

Excel 2007. I dont want to use macro.

I dont want to send workbooks by email and so on forever to get their hours into my workbook.

I know this is simple to do, but my brain has stopped working

Thanks a lot for all help

 

[AlphaFrog]

Create an external reference (link) to a cell range in another workbook.

MrExcel Video:
How to Update Excel 2007 External links

 

[Kyrre]

Thank you a lot for responding to my issue!

I knew about that trick to copy a cell in workbook1 and paste it into workbook2, but it didn`t work beacuse I did something wrong with OneDrum-files and lokal files. It cannot be synced, so I have to use OneDrum for all files that is linked to each other.

Is there any other way to do this?

Share files like this, or to sync data between diff workbooks?

Thanks a lot once again!

 

[Kyrre]

It works, but I need to update in an anothter way. I need to set up my workbook to update from web. I`ll search how to set up web-excel or something like that. Any hints?