Excel- Change Cell string Value based on changeable column in another spreadsheet

0
votes

I need a dynamic way to change a Cell value " for example : Sheet2!A2 " whenever a cell column in Sheet1 has changed

For example: Sheet2!A2= is the cell I want to paste the value

Sheet!B:B= is the column that I insert a string on it.

Whenever I add a value in B:B, this value automatically paste on Sheet2!A2. And when I add another value in B:B or update any cell in B:B, the newest added value automatically pasted on Sheet2!A2. and so on.

Please help me, I think I need to use a VB code or something.

Best

1
excelvba

1 Answers

3
votes

You can enter the following formula in the cell Sheet2!A2, you will get what you wanted.

=IF(IFERROR(FIND("Sheet1!$B",CELL("address"),1),0)=0,"",CELL("contents"))

While pasting this formula if you get any warning or error message, Just press enter or click on Ok.