Easy one here, table cell return value from another cell [SOLVED]

[rjwalters]

I know how to do this, but I have an issue. I have A1= A1 on sheet 2. But instead of returning the value, it returns the formula. Thoughts?

 

[rjwalters]

I think it has to do with A1 being in a table.

 

[rjwalters]

I got it, there were hyperlinks in cell A1, which was causing it to have the issue.

 

[SirJB7]

Hi, rjwalters!

Glad you solved it by yourself, welcome to the self-service section at Chandoo's website

Regards!

 

[rjwalters]

I find that the more I am on here, the less questions I have to ask ... which is a good thing...

 

[SirJB7]

Hi, rjwalters!

And the best thing hasn't arrived yet... the increasingly more questions you'd may answer.

Regards!

 

[Hui]

RJ


Often asking the questions causes you to think about how to phrase the question so that other people understand. This process in itself allows you to step outside the immediate problem and results in your brain having time to think about what the real problem is.


Wow that sounds deep and meaningful.


But anyway it works a lot.