I've sort of two cells in different sheets... if i update one of the
cells then it will automatically update the other one... and VISE VERSA

Think you need vba for this. Hang around for insights from others.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--