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....