If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summary worksheet within a workbook
I'm sure this is an easy formula, but I need some help....
I have a workbook where a tab is added with each day's activity. I'm looking to add a summary page that will pick up the data from all tabs starting on line 6 of each tab (including additional tabs that may be added). Any suggestions? Thanks |
#2
|
|||
|
|||
Summary worksheet within a workbook
You'll want to look into 3D functions, assuming you're wanting to gather
sums/counts of data. -- Best Regards, Luke M "nitengale" wrote in message ... I'm sure this is an easy formula, but I need some help.... I have a workbook where a tab is added with each day's activity. I'm looking to add a summary page that will pick up the data from all tabs starting on line 6 of each tab (including additional tabs that may be added). Any suggestions? Thanks |
#3
|
|||
|
|||
Summary worksheet within a workbook
I think I need to specify a little more here -
I'm not looking for a subtotal, but rather to take all the data from all worksheets and dump it into one without having to copy and paste from each sheet. For example tab #20 has 5 lines of data - add it to the bottom of a summary tab that has the data from tabs 1 thru 19. "nitengale" wrote: I'm sure this is an easy formula, but I need some help.... I have a workbook where a tab is added with each day's activity. I'm looking to add a summary page that will pick up the data from all tabs starting on line 6 of each tab (including additional tabs that may be added). Any suggestions? Thanks |
#4
|
|||
|
|||
Summary worksheet within a workbook
Luke - I've tried looking under this already and am stuck. I'm not looking
for sums, but rather a dump of data from multiple spreadsheets into one "summary" sheet. "Luke M" wrote: You'll want to look into 3D functions, assuming you're wanting to gather sums/counts of data. -- Best Regards, Luke M "nitengale" wrote in message ... I'm sure this is an easy formula, but I need some help.... I have a workbook where a tab is added with each day's activity. I'm looking to add a summary page that will pick up the data from all tabs starting on line 6 of each tab (including additional tabs that may be added). Any suggestions? Thanks . |
#5
|
|||
|
|||
Summary worksheet within a workbook
Nitengale,
Did you ever figure this out? I'm looking for exactly the same kind of summary sheet, but can't seem to figure it out either. This doesn't seem like it should be a difficult task to complete, but I haven't figured out the formula. Please let me know if you make any progress. Thanks... "nitengale" wrote: I think I need to specify a little more here - I'm not looking for a subtotal, but rather to take all the data from all worksheets and dump it into one without having to copy and paste from each sheet. For example tab #20 has 5 lines of data - add it to the bottom of a summary tab that has the data from tabs 1 thru 19. "nitengale" wrote: I'm sure this is an easy formula, but I need some help.... I have a workbook where a tab is added with each day's activity. I'm looking to add a summary page that will pick up the data from all tabs starting on line 6 of each tab (including additional tabs that may be added). Any suggestions? Thanks |
Thread Tools | |
Display Modes | |
|
|