i have 2 workshets

1st one is for puchases
2nd one is for sales

now i want to open the 3rd sheet as stock. when i enter the sales
it is automatically show values in stock file.

any one tell me which can i uses the functions.


--
somaraju
------------------------------------------------------------------------
somaraju's Profile: http://www.excelforum.com/member.php...o&userid=31846
View this thread: http://www.excelforum.com/showthread...hreadid=515696