Greetings,

I would like to ask whether there is any way, to connect one excel table into another, but with "back compability" meaning: I will change/add something in table 1 -> it changes in table 2, as well as, I change something in table 2 -> it changes in table 1 as well... Right now I'm only able to get the data from one table into another but I'm really clueless, on how to do it all the way back. To give you the real life situation for this, so you can imagine it better. In my job, we are currently writing orders into excel sheet in order to keep track of everything, but there is one thing, we as an employees cannot see and that being that "status" of the order... The only one able to see this is the manager. So he has to open every table of every employee and overwrite it over there... so I'm asking whether there is a way to make one "master" table (in which there will be all of the info from the tables of employees taken from all the different files) , and which will update the changes made to the "status" of the order and change it in the table of each employee ...
Hopefully you will be able to help me with this issue since I have been struggling with it for quite some time... (Also note that there is no microsoft access available... and we are working with microsoft excel 2007)

Thanks a lot for future help! ^^
Have a nice day