If you want to link to a cell you can just copy that cell, then do
editpaste special and select paste link


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"buggu" wrote in
message ...

How do i use subtotal function results from one worksheet in another
work sheet. I am able to work out average price of raw materals brought
but would liked it automatically linked to my profit forecast and actual
sales worksheet.

Or is there an easier way for me to have stock control and sales data
linked?


--
buggu
------------------------------------------------------------------------
buggu's Profile:
http://www.excelforum.com/member.php...o&userid=36667
View this thread: http://www.excelforum.com/showthread...hreadid=564121