| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Workbook Summary Data from Sheets
How do I create a summary sheet that will automatically include all data from
several columns on three separate sheets from the same workbook? |
|
#2
|
|||
|
|||
|
Hi
and how do you want to merge them exactly (sum the values?) -- Regards Frank Kabel Frankfurt, Germany "Solis" schrieb im Newsbeitrag ... How do I create a summary sheet that will automatically include all data from several columns on three separate sheets from the same workbook? |
|
#3
|
|||
|
|||
|
I want to merge the separate lists into one master list. Each sheet has 6
columns that share the same headings (i.e. last name, first name, cost, etc) and they also have columns with diferent headings and different data. I would like to compile a complete list of all the data from the 6 common columns from each of the 3 separate sheets on one new sheet. (Hope this makes sense!) "Frank Kabel" wrote: Hi and how do you want to merge them exactly (sum the values?) -- Regards Frank Kabel Frankfurt, Germany "Solis" schrieb im Newsbeitrag ... How do I create a summary sheet that will automatically include all data from several columns on three separate sheets from the same workbook? |
|
#4
|
|||
|
|||
|
Hi
and a simple copy and paste procedure does not work? -- Regards Frank Kabel Frankfurt, Germany "Solis" schrieb im Newsbeitrag ... I want to merge the separate lists into one master list. Each sheet has 6 columns that share the same headings (i.e. last name, first name, cost, etc) and they also have columns with diferent headings and different data. I would like to compile a complete list of all the data from the 6 common columns from each of the 3 separate sheets on one new sheet. (Hope this makes sense!) "Frank Kabel" wrote: Hi and how do you want to merge them exactly (sum the values?) -- Regards Frank Kabel Frankfurt, Germany "Solis" schrieb im Newsbeitrag ... How do I create a summary sheet that will automatically include all data from several columns on three separate sheets from the same workbook? |
|
#5
|
|||
|
|||
|
No, I was hoping to find a way to automate this. Can't simply copy and paste
entire rows because not all data will be used in summary, and all columns that will be used in summary are not all directly next to each other. "Frank Kabel" wrote: Hi and a simple copy and paste procedure does not work? -- Regards Frank Kabel Frankfurt, Germany "Solis" schrieb im Newsbeitrag ... I want to merge the separate lists into one master list. Each sheet has 6 columns that share the same headings (i.e. last name, first name, cost, etc) and they also have columns with diferent headings and different data. I would like to compile a complete list of all the data from the 6 common columns from each of the 3 separate sheets on one new sheet. (Hope this makes sense!) "Frank Kabel" wrote: Hi and how do you want to merge them exactly (sum the values?) -- Regards Frank Kabel Frankfurt, Germany "Solis" schrieb im Newsbeitrag ... How do I create a summary sheet that will automatically include all data from several columns on three separate sheets from the same workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
| Updating sheets within a workbook | Excel Discussion (Misc queries) | |||
| How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) | |||
Linear Mode
