How do you return all sheets of a workbook to cell A1 all together?

glenlee, one way, group the sheets and select A1, ungroup the sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"glenlee" wrote in message
...
How do you return all sheets of a workbook to cell A1 all together?

Grouping the sheets is not working....only one sheet goes back to cell
A1

On Sat, 24 Sep 2005 19:10:58 -0400, "Paul B"
wrote:

glenlee, one way, group the sheets and select A1, ungroup the sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"glenlee" wrote in message
...
How do you return all sheets of a workbook to cell A1 all together?

glenlee, if you group the sheets and click on cell A1 that should select
cell A1 on all the sheets, ungroup the sheets before you do anything else.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"glenlee" wrote in message
...
Grouping the sheets is not working....only one sheet goes back to cell
A1

On Sat, 24 Sep 2005 19:10:58 -0400, "Paul B"
wrote:

glenlee, one way, group the sheets and select A1, ungroup the sheets

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"glenlee" wrote in message
...
How do you return all sheets of a workbook to cell A1 all together?

Do you by chance mean you wish to Sum cell A1 form sheet2 through sheet100
and place it in cell A1 of sheet1?
If so in cell A1 of sheet1 enter:
=SUM(Sheet2:Sheet100!A1)

HTH

"glenlee" wrote in message
...
How do you return all sheets of a workbook to cell A1 all together?