Short cut to refer a cell in diference worksheet

[aclim]

I need to summary a data from difference worksheet, but same cell in each
worksheet, instead of type'=' then click on cell in each work sheet
repeatedly, any shut cut?

 

[Gaijintendo]

The formula that will generate will be something like:
=Sheet2!A1

Cell A1 in that sheet
If the sheet name has a space the Sheet1 might become 'Sheet 1'

You could prep all your references in notepad if its easier for you and just
plop them in for each one. But you have to be specific about which cell you
are referring to.

 

[Pete_UK]

Do you mean that you want to sum the same cell from different
worksheets? If so, you can insert 2 new worksheets called "start" and
"end", and move them so they encompass the sheets you want to sum from
rather like a sandwich. Then you can use this formula:

=start:end!A1

Hope this helps.

Pete

 

[aclim]

Thank 'Gaijintendo', for sumary like :
=Sheet2!A1
=Sheet3!A1
=Sheet4!A1
=Sheet5!A1
=Sheet6!A1
Any short cut for this action?

 

[Gaijintendo]

you could make column A in a blank sheet be numbers 1, 2, 3 etc (paste the
format down the column)
Then make the formula, of column B be =concatenate("Sheet",A1,"!A1")

then copy the contents of column B and "Paste Special -> Values"

But you probably mean in a more general sense... And I don't know of any way
to program this with Visual Basic or such :-S Sorry.

 

[aclim]

Thank "Pete_UK" for useful short cut, how about if the case that i have few
work sheet name as:
Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6
Sheet7
Sheet8

But for summary in the next worksheet, I like to collect all data in above
worksheet, the formula in cell will be:
Cell A1 in summary sheet will be =Sheet1!A1
Cell A2 in summary sheet will be =Sheet2!A1
Cell A3 in summary sheet will be =Sheet3!A1
Cell A4 in summary sheet will be =Sheet4!A1...etc
Any short cut for this action?

 

[Pete_UK]

In your summary sheet you can use a formula like this:

=INDIRECT("'Sheet"&ROW(A1)&"'!A1")

and then copy this down as required.

Hope this helps.

Pete

 

[Pete_UK]

NOTE: this should have been:

=SUM(start:end!A1)

Sorry about that.

Pete