I've a workbook with 1 project management sheet and several sheets with
testdata. The project management sheet I use for instance to show total
figures. For example. I want to make totals for sheet1!A1 + sheet2!A1 +
sheet3!A1. As you see the position of the cells remanes the same. Easy
you say....but what I don't know is: how many sheets shall I have, and
I don't want to adapt everytime my formulas after adding a sheet
I there a possibility to say take all the sheets where the name of the
sheet begins with xxx and make a sum of cell A1?

thanks in advance.

david


--
daolb
------------------------------------------------------------------------
daolb's Profile: http://www.excelforum.com/member.php...o&userid=24478
View this thread: http://www.excelforum.com/showthread...hreadid=381509