| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Many thanks for the help, it worked a treat alas no the bar has risen a smidgen. Now I have to try and somehow grab a few sheets (all with the title totals) from different workbooks and from those different sheets generate an overall totals sheet. The columns on the individual totals sheets are all the same. So I think the total problem is: - somehow allowing the user to indicate what workbooks they want to grab the totals sheets from - taking all the data off these total sheets and then creating an "ultimateTotals" sheet... If anybody has any ideas or suggestions as to how this could be done (if it can be done) twould be great, Many thanks Tony -- tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access |
|
#2
|
|||
|
|||
|
Hi Tony
Try this http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "tonyDeBrasco" <tonyDeBrasco.1ske3y@ wrote in message ... Many thanks for the help, it worked a treat alas no the bar has risen a smidgen. Now I have to try and somehow grab a few sheets (all with the title totals) from different workbooks and from those different sheets generate an overall totals sheet. The columns on the individual totals sheets are all the same. So I think the total problem is: - somehow allowing the user to indicate what workbooks they want to grab the totals sheets from - taking all the data off these total sheets and then creating an "ultimateTotals" sheet... If anybody has any ideas or suggestions as to how this could be done (if it can be done) twould be great, Many thanks Tony -- tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
| Need to have multiple worksheets use a single worksheet | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
