| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to summarize 3-4 worksheets worth of data into a summary scree
Hi all
As aprt of doing a mail merge I need data from 3 worksheets to be summarised in a 4th worksheet for mail merge reasons. So what i have currently is a bunch of colums and rows whcih will continously added to. Currently have around 100 candicates and on each person there are several further colums for their data. Each person has a similar setup in 2 other worksheets for different sets of data. What i want is basically the 4th worksheet to show all of these and also whenever more data is added to either sheet, this is added to the 4th worksheet.... Thanks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to summarize 3-4 worksheets worth of data into a summary scree
Gareth,
I recommend starting he http://www.rondebruin.nl/tips.htm -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Hi all As aprt of doing a mail merge I need data from 3 worksheets to be summarised in a 4th worksheet for mail merge reasons. So what i have currently is a bunch of colums and rows whcih will continously added to. Currently have around 100 candicates and on each person there are several further colums for their data. Each person has a similar setup in 2 other worksheets for different sets of data. What i want is basically the 4th worksheet to show all of these and also whenever more data is added to either sheet, this is added to the 4th worksheet.... Thanks in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to summarize 3-4 worksheets worth of data into a summary s
Thanks thomas
i have had a look at this and seems somewhart complicated for what i am asking. "Thomas [PBD]" wrote: Gareth, I recommend starting he http://www.rondebruin.nl/tips.htm -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Hi all As aprt of doing a mail merge I need data from 3 worksheets to be summarised in a 4th worksheet for mail merge reasons. So what i have currently is a bunch of colums and rows whcih will continously added to. Currently have around 100 candicates and on each person there are several further colums for their data. Each person has a similar setup in 2 other worksheets for different sets of data. What i want is basically the 4th worksheet to show all of these and also whenever more data is added to either sheet, this is added to the 4th worksheet.... Thanks in advance. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to summarize 3-4 worksheets worth of data into a summary s
Gareth,
Are all of these Worksheets in the same Workbook? It can be easier to write a macro to combine the information into the 4th sheet if so. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Thanks thomas i have had a look at this and seems somewhart complicated for what i am asking. "Thomas [PBD]" wrote: Gareth, I recommend starting he http://www.rondebruin.nl/tips.htm -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Hi all As aprt of doing a mail merge I need data from 3 worksheets to be summarised in a 4th worksheet for mail merge reasons. So what i have currently is a bunch of colums and rows whcih will continously added to. Currently have around 100 candicates and on each person there are several further colums for their data. Each person has a similar setup in 2 other worksheets for different sets of data. What i want is basically the 4th worksheet to show all of these and also whenever more data is added to either sheet, this is added to the 4th worksheet.... Thanks in advance. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to summarize 3-4 worksheets worth of data into a summary s
Hi Thomas
yes all 3 worksheets are in same workbook / file. ta "Thomas [PBD]" wrote: Gareth, Are all of these Worksheets in the same Workbook? It can be easier to write a macro to combine the information into the 4th sheet if so. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Thanks thomas i have had a look at this and seems somewhart complicated for what i am asking. "Thomas [PBD]" wrote: Gareth, I recommend starting he http://www.rondebruin.nl/tips.htm -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Hi all As aprt of doing a mail merge I need data from 3 worksheets to be summarised in a 4th worksheet for mail merge reasons. So what i have currently is a bunch of colums and rows whcih will continously added to. Currently have around 100 candicates and on each person there are several further colums for their data. Each person has a similar setup in 2 other worksheets for different sets of data. What i want is basically the 4th worksheet to show all of these and also whenever more data is added to either sheet, this is added to the 4th worksheet.... Thanks in advance. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to summarize 3-4 worksheets worth of data into a summary s
Gareth,
Here is a quick macro that seems to work, as I dont know your criteria or columns etc... its a rough idea of what could be done. Note: please create a tab named "Summary" Public Sub Comb_Summary() For Each sh In Sheets sh.Select If ActiveSheet.Name < "Summary" Then sh.UsedRange.Copy Sheets("Summary").Select x = WorksheetFunction.CountA(Columns("A:A")) Cells(x + 1, 1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False If x < 0 Then Rows(x + 1).Delete End If End If Next End Sub -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Hi Thomas yes all 3 worksheets are in same workbook / file. ta "Thomas [PBD]" wrote: Gareth, Are all of these Worksheets in the same Workbook? It can be easier to write a macro to combine the information into the 4th sheet if so. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Thanks thomas i have had a look at this and seems somewhart complicated for what i am asking. "Thomas [PBD]" wrote: Gareth, I recommend starting he http://www.rondebruin.nl/tips.htm -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Gareth" wrote: Hi all As aprt of doing a mail merge I need data from 3 worksheets to be summarised in a 4th worksheet for mail merge reasons. So what i have currently is a bunch of colums and rows whcih will continously added to. Currently have around 100 candicates and on each person there are several further colums for their data. Each person has a similar setup in 2 other worksheets for different sets of data. What i want is basically the 4th worksheet to show all of these and also whenever more data is added to either sheet, this is added to the 4th worksheet.... Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help using data from multiple worksheets to create a Summary | Excel Discussion (Misc queries) | |||
| summarize data from multiple worksheets | Excel Discussion (Misc queries) | |||
| help need to total a months worth of worksheets into one report | New Users to Excel | |||
| Creating a summary sheet from data across multiple worksheets | Excel Discussion (Misc queries) | |||
| Summarize multiple worksheet detail on summary sheet | Excel Discussion (Misc queries) | |||
![Gareth[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
