I am trying to link cells from a shared worksheet to my spreadsheet. I got
the linking down but I want to use a logical argument. In other words, if
the value of column A on the shared worksheet is greater than SHAW000, then I
want that cell to link to my spreadsheet. If the value is not greated than
SHAW000 than don't link it. Can anyone help with this? Thanks.

What do you mean by "link"? You can use an IF statement.
IF(test_condition,true,false). Nothing unusual here.

Tyro

"patsy" wrote in message
...
I am trying to link cells from a shared worksheet to my spreadsheet. I got
the linking down but I want to use a logical argument. In other words, if
the value of column A on the shared worksheet is greater than SHAW000,
then I
want that cell to link to my spreadsheet. If the value is not greated
than
SHAW000 than don't link it. Can anyone help with this? Thanks.

I am linking a cell from a shared worksheet to my worksheet and I only want
my information to link. All these cells that I will enter will start with
SHAW. Those are the only entries that I want linked to my own worksheet. If
the cell starts with anything other than SHAW, I don't want it to link. Hope
this explains what I am looking for.

"Tyro" wrote:

What do you mean by "link"? You can use an IF statement.
IF(test_condition,true,false). Nothing unusual here.

Tyro

"patsy" wrote in message
...
I am trying to link cells from a shared worksheet to my spreadsheet. I got
the linking down but I want to use a logical argument. In other words, if
the value of column A on the shared worksheet is greater than SHAW000,
then I
want that cell to link to my spreadsheet. If the value is not greated
than
SHAW000 than don't link it. Can anyone help with this? Thanks.