If you need to distribute the detailed information then you have a big up
hill battle requiring a bunch of custom macro code. If all you need is the
summary details then perhaps SumProduct Formulas will do the trick.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...
Jim Thomlinson
"Bob" wrote:
Thanks....I don think a pivot table would do in this instance,since I have
other data(formulas) in the individual sheets. I need to link the cell
somehow but am not sure how to do that.
--
Bob
"Jim Thomlinson" wrote:
Depending on exactly how your data looks a pivot table might work for you. If
you have never used a pivot table check out this link...
http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
HTH...
Jim Thomlinson
"Bob" wrote:
I have a Master sheet with sales data - for example Salesman Name, Customer
Name, 2007 total and monthly 2008 totals. I then have individual sheets for
each Salesman with customer Name, 2007 total and monthly 2008 totals. What I
would like to do is each month dump the data in the master spreadsheet and
have the inidividual sheets automatically updated. How can I link the
subsheets to the master sheet?
Thanks.
--
Bob