please help, my boss is going to kill me!

  • Thread starter Thread starter m
  • Start date Start date
M

m

I'm trying to use one worksheet as a summary sheet with
each row's cells in that summary sheet corresponding to
specific cells within a new worksheet.

How do I get Excel to generate a new worksheet with the
proper corresponding functions in the cells?

Ie, so they correspond to the new row in the summary sheet.
Summary sheet row a = worksheet a
Summary sheet row b = worksheet b
etc...

Thanks in advance
 
"m",

Not sure about
proper corresponding *functions* in the cells?
Click to expand...

, but you can cross-re stuff, eg: =Sheet1!A1

Harassment at work is now recognised as one of the major contributing
factors to unnecessary stress. Use your union or professional organisation.
That's what they're there for.

Rgds,
Andy
 
thanks - i'm trying to automate it so i don't have to
cross reference each cell everytime i start a new line on
the summary sheet - there is about 20 cells that need a
formula entered.
 
What you're trying to do is not clear to me, however you can do multi-entry.
Select eg: A1:T1, enter your formula, then press CTRL+Enter. If that helps
at all.

Rgds,
Andy
 
if you have the worksheet letters in column a, and the
summary equation in column b (as such):

A B
a summary on worksheet a
b summary on worksheet b
c summary on worksheet c
..
..
..

you can use the INDIRECT equation to capture the text in
column a. the equation you could put in b2 (assuming you
wanted to sum the cells from A1:A1000 on each of the
different worksheets) would be:

=SUM(INDIRECT("'worksheet "&A2&"'!$A$1:$A$1000"))

Hope that helps,
Karen
 
Back
Top