guys need ur help....


its an estimate form...say

Sheet 1 = where I key in datas
Sheet 2 = master form

example:

Sheet 1 Sheet 2
Est No. A B C Total Est No.
Total
Est 101 2 4 2 16 Est 101
16


When I have new data to put I go to Sheet 1 using the same cells I just
change the default value...


Sheet 1 Sheet
2
Est No. A B C Total Est No.
Total
Est 102 5 2 3 30 Est 101
16
Est
102 30

In Short everytime I have a new data I have to put in Sheet 1
and Sheet 2 will be updated without changing the previous datas that
you have inputted....


--
hennessey
------------------------------------------------------------------------
hennessey's Profile: http://www.excelforum.com/member.php...o&userid=31938
View this thread: http://www.excelforum.com/showthread...hreadid=516824