| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarize Data and automatically update including adding rows
I can't figure out the best way to do this:
I have 3 input data sheets. Contribution info from 3 sources. Each has difference sections of info. They want a 4th sheet that is the summary sheet that adds all of the other sheets and is automatically sorted without the user doing anything. My boss wants to input data on any of the three sheets and have it automatically appear in the correct place on the summary sheet. I know how to link when the source is known, but how do you make new rows automatically get added and in the correct alpha order on another worksheet?? I was thinking something like 3-D references and ranges. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summarize Data and automatically update including adding rows
Hi,
This probably won't be much help to you, but multiple data sources with a common link between them really is a job for Access, not excel. If you moved this into access it would solve all your problems. Thanks, Simon Dawnaha wrote: I can't figure out the best way to do this: I have 3 input data sheets. Contribution info from 3 sources. Each has difference sections of info. They want a 4th sheet that is the summary sheet that adds all of the other sheets and is automatically sorted without the user doing anything. My boss wants to input data on any of the three sheets and have it automatically appear in the correct place on the summary sheet. I know how to link when the source is known, but how do you make new rows automatically get added and in the correct alpha order on another worksheet?? I was thinking something like 3-D references and ranges. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200610/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summarize Data and automatically update including adding rows
Sorry...clicked Post too early!
However, as long as there is a colum which can be used to link all of the data rows (eg sheet 1 has part number and name, sheet 2 has part number and price, sheet 3 has part number and weight etc.) then you can link upto 4 data sources through a pivot table. To cope with your data entry, set the pivot ranges to, say, row 10,000 then all you have todo is refresh the pivot ever time. HTH Simon Dawnaha wrote: I can't figure out the best way to do this: I have 3 input data sheets. Contribution info from 3 sources. Each has difference sections of info. They want a 4th sheet that is the summary sheet that adds all of the other sheets and is automatically sorted without the user doing anything. My boss wants to input data on any of the three sheets and have it automatically appear in the correct place on the summary sheet. I know how to link when the source is known, but how do you make new rows automatically get added and in the correct alpha order on another worksheet?? I was thinking something like 3-D references and ranges. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200610/1 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summarize Data and automatically update including adding rows
Thanks for the input and no, it doesn't help. This is for my boss who doesn't
have Access or know how to use it at all. :( "smw226 via OfficeKB.com" wrote: Hi, This probably won't be much help to you, but multiple data sources with a common link between them really is a job for Access, not excel. If you moved this into access it would solve all your problems. Thanks, Simon Dawnaha wrote: I can't figure out the best way to do this: I have 3 input data sheets. Contribution info from 3 sources. Each has difference sections of info. They want a 4th sheet that is the summary sheet that adds all of the other sheets and is automatically sorted without the user doing anything. My boss wants to input data on any of the three sheets and have it automatically appear in the correct place on the summary sheet. I know how to link when the source is known, but how do you make new rows automatically get added and in the correct alpha order on another worksheet?? I was thinking something like 3-D references and ranges. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200610/1 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Summarize Data and automatically update including adding rows
I'll figure out how to make that work. I knew I had just learned a way, and
have just been lost trying to remember it! You are great! "smw226 via OfficeKB.com" wrote: Sorry...clicked Post too early! However, as long as there is a colum which can be used to link all of the data rows (eg sheet 1 has part number and name, sheet 2 has part number and price, sheet 3 has part number and weight etc.) then you can link upto 4 data sources through a pivot table. To cope with your data entry, set the pivot ranges to, say, row 10,000 then all you have todo is refresh the pivot ever time. HTH Simon Dawnaha wrote: I can't figure out the best way to do this: I have 3 input data sheets. Contribution info from 3 sources. Each has difference sections of info. They want a 4th sheet that is the summary sheet that adds all of the other sheets and is automatically sorted without the user doing anything. My boss wants to input data on any of the three sheets and have it automatically appear in the correct place on the summary sheet. I know how to link when the source is known, but how do you make new rows automatically get added and in the correct alpha order on another worksheet?? I was thinking something like 3-D references and ranges. -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200610/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
| Create charts that update automatically from data in rows | Charts and Charting in Excel | |||
| How do I automatically update a graph after adding a data point | Charts and Charting in Excel | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Linear Mode
