ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Logical arguments and linking (https://www.excelbanter.com/excel-discussion-misc-queries/172723-logical-arguments-linking.html)

patsy

Logical arguments and linking
 
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.

Tyro[_2_]

Logical arguments and linking
 
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.




patsy

Logical arguments and linking
 
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.






All times are GMT +1. The time now is 02:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com