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

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

I guess what i meant was whether there was of a way of have subtotals
automatically done. It just that i,m having to manually do the
subtotals and then manually special paste them in the other work
sheets.

Would it be best instead to have seprate worksheets for each particular
item. That way i be able to work out totals, average price paid etc
automaically using formulas. At present i simply have one work sheet
for logging all purchases.


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