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

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

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

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