Logical arguments and linking

  • Thread starter Thread starter patsy
  • Start date Start date
P

patsy

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying linked sheet 2
Excel VBA 1
Linking Formulae Across a Workbook 2
Links 4
Paste Values in linked Cells Only 4
Links error when insert line/row to source workbook 1
Stop linked cells from changing when insert new row? 1
Sorting non-linked cells in a linked worksheet 1

Back
Top