Working with worksheets

  • Thread starter Thread starter james
  • Start date Start date
J

james

Hi out there

Please I need help with working between worksheets. I have some values in
work sheet 2 which I need to correspond with results in worksheet 1. How do I
go about it
 
James,

A bit short on detail but at its simplest this

=Sheet2!A1

in a cell on sheet 1 (or in fact any sheet) would return the value in sheet
2 cell A1

Mike
 
Just link the cells in sheet2 to the cells in sheet1

Something like this

=Sheet1!A1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Wed said:
Hi out there

Please I need help with working between worksheets. I have some values in
work sheet 2 which I need to correspond with results in worksheet 1. How do I
go about it
Click to expand...

In Sheet 1, to reference cell C187 from Sheet 2 use
='Sheet 2'!C187

The '' are necessary if the sheet name contains spaces or other
special characters, but they're always harmless. The ! separates
sheet name from cell reference.
 
Thanks Mike. My problem got solved. I have another question. Can I use the
"the formula is" under conditional formating to get a cell to indicate a
colour. And if yes how. I know that with a "value is" and formating one can
do that.

Thanks in advance

"Mike H" skrev:
 
Hi James,

It all depends on what you want to achieve but a simple example is..

Say that you want cell B1 to turn red when cell A1 = 1

In cell B1 set conditional formatting> Formula is > =A1=1 and set the
patterns to red

Hope this helps,

Gav.
 
Why not try it? Just remember to start your formula with an = sign, as
otherwise Excel tends to guess that what you've put in is a text string.
 
Back
Top