Need a formula to move data

Copper 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.

rahul_oberoi_0-1637555314763.png

 

 

1 Reply

Paste this formula into Sheet3 in A1.

=Sheet1!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.