![]() |
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. |
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. |
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