Insert a link to cell where values are copied

[marcvanderpeet12]

Dear all,

I have the following situation:

I created a link from a cell in tab1 to a cell in tab2. No I would like to include that, dependent on how I enter the information in tab1, the information shows in the cell in tab 2.

So if I enter 7% it should give 7% and when I enter 23,23 it should give 23,23.

Anybody a clue on how I can fix this?

Thanks in advance and regards!

Groeten,

Marc

 

[sgmpatnaik]

@Marc

as per my understanding say your data in Tab1 Range A1 = 7%

in tab2 Range A2 write this

='Tab1'!A1

what ever you enter in Tab1 in the Range A1 it will reflect in the Tab2 Range A1

Hope it clear

Thank

 

[SirJB7]

Hi, marcvanderpet12!
I didn't understand it at all, could you please elaborate, if sgmpatnaik didn't hit in the nail?
Regards!