Working with worksheets
 

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

Working with worksheets
 

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

"james" wrote:

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

Working with worksheets
 

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)



"james" wrote in message
...
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

Working with worksheets
 

Wed, 9 Jan 2008 03:41:00 -0800 from 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

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Working with worksheets
 

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:

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

"james" wrote:

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

Working with worksheets
 

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.

"james" wrote:

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:

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

"james" wrote:

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

Working with worksheets
 

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"james" wrote in message
...
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:

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

"james" wrote:

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

Working with worksheets
 

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.
--
David Biddulph

"james" wrote in message
...
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:

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

"james" wrote:

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