Updating indivudal sheets thru a Master sheet
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 |
Updating indivudal sheets thru a Master sheet
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 |
Updating indivudal sheets thru a Master sheet
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 |
Updating indivudal sheets thru a Master sheet
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 |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com