G
glenlee
How do you return all sheets of a workbook to cell A1 all together?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul B
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
--
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
G
glenlee
Grouping the sheets is not working....only one sheet goes back to cell
A1
A1
P
Paul B
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
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
J
Jim May
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
and place it in cell A1 of sheet1?
If so in cell A1 of sheet1 enter:
=SUM(Sheet2:Sheet100!A1)
HTH