software

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
16When 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: www.excelforum.com/member.php...oamp;userid=31938
View this thread: www.excelforum.com/showthread...hreadid=516824If I understand you correctly, you want to do estimates in Sheet 1, and then
at some stage, say at print stage, you want the detail of every estimate
copied to a second sheet, to keep record of all estimates done.

You can achieve this with a macro, say linked to a print button, which will
print out the estimate, copy the info to sheet 2, where it will insert it
after the last used row, and then clear out the estimate form on sheet 1.

You can find the next unused row with the .Cells(.Rows.Count,
quot;Aquot;).End(xlUp).Row)

quot;hennesseyquot; wrote:

gt;
gt; guys need ur help....
gt;
gt;
gt; its an estimate form...say
gt;
gt; Sheet 1 = where I key in datas
gt; Sheet 2 = master form
gt;
gt; example:
gt;
gt; Sheet 1 Sheet 2
gt; Est No. A B C Total Est No.
gt; Total
gt; Est 101 2 4 2 16 Est 101
gt; 16
gt;
gt;
gt; When I have new data to put I go to Sheet 1 using the same cells I just
gt; change the default value...
gt;
gt;
gt; Sheet 1 Sheet
gt; 2
gt; Est No. A B C Total Est No.
gt; Total
gt; Est 102 5 2 3 30 Est 101
gt; 16
gt; Est
gt; 102 30
gt;
gt; In Short everytime I have a new data I have to put in Sheet 1
gt; and Sheet 2 will be updated without changing the previous datas that
gt; you have inputted....
gt;
gt;
gt; --
gt; hennessey
gt; ------------------------------------------------------------------------
gt; hennessey's Profile: www.excelforum.com/member.php...oamp;userid=31938
gt; View this thread: www.excelforum.com/showthread...hreadid=516824
gt;
gt;