Need a formula to move data

Occasional Contributor

Hi Expert, 


Need the formula to move the data in another sheet. 

Let's say, I want to move the data as soon as the value of a column in changes to c 

value of columns A, B, C move to sheet 3.




1 Reply

Paste this formula into Sheet3 in A1.

scroll down
The same for column B and C

I don't know if that is what is meant, but I hope I have helped.