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