How can I automatically transfer my text from one sheet to another in Excel? I mean whenever I put or write any text in a sheet in 1 it should also automatically be written in sheet 2.
Is there any formula for this??
Now, I have attached the file, as you can see first I have to put all the data in the sheet no.2 named as "data center" then I have to put in sheet one. What I want is that whenever I put data in sheet 2 it should automatically come in the sheet no.1 also.
Solved by O. J. in 19 mins