Your tip did work so far but there is one more thing ; -
Formula works, except what we need is that whenever data is changed in
sheets Red, yellow or Green (individually) then that data is also updated
into the WS1 sheet.

Thank you

"Markv" wrote:

Hey there Max you seem to be on top of things.
I need to update several other idividual spreadsheets from my master sheet.
ie. if i should type a project in text under Joe's name upon saving or
clicking away this update must go to his sheet on his computer and
automatically update what I typed.

"Max" wrote:

welcome, good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NBROWN" wrote in message
...
Max,

Thank you....That worked for me beautifully....