| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying summary information in a workbook
Basically this is what I want to do
I have a excel work book, with 7 worksheets / tabs, what I want to do is summerise all the (6) worksheets /tabs contents on the first worksheet, now the data will be tables ie name, field 1, field 2, field 3, all the workseets will have the same number of column headings. Now the 6 other work sheet lengths will vary from time to time, grow & shrink, but what I want to have on the first spreed sheet is a single list, the information doesn't need to be able to be sorted on the first page (but if it could it would be great). I have though of using ranges and then "pasting the ranges into the first worksheet" but you would have to keep adjusting the range to fit the length of the data on all the pages, and the question is how would ensure that all the data would be displayed in a single block, rather than seperate blocks. Does anybody have any ideas how I solve this problem? Can't really use Access (it needs to be in excel format). Thanking you in advance for your time and consideration. David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying summary information in a workbook
How to solve the problem would be to write some VBA.
I don't know what the relevant code would be, though. "Le Tubs" wrote: Basically this is what I want to do I have a excel work book, with 7 worksheets / tabs, what I want to do is summerise all the (6) worksheets /tabs contents on the first worksheet, now the data will be tables ie name, field 1, field 2, field 3, all the workseets will have the same number of column headings. Now the 6 other work sheet lengths will vary from time to time, grow & shrink, but what I want to have on the first spreed sheet is a single list, the information doesn't need to be able to be sorted on the first page (but if it could it would be great). I have though of using ranges and then "pasting the ranges into the first worksheet" but you would have to keep adjusting the range to fit the length of the data on all the pages, and the question is how would ensure that all the data would be displayed in a single block, rather than seperate blocks. Does anybody have any ideas how I solve this problem? Can't really use Access (it needs to be in excel format). Thanking you in advance for your time and consideration. David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying information (contained in defined names) on a summary sheet, in different row numbers? | Excel Discussion (Misc queries) | |||
| Shared Workbook not displaying properly | Excel Discussion (Misc queries) | |||
| Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
| How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
| Displaying YTD totals as you populate monthly information | Excel Worksheet Functions | |||
Linear Mode
