how to sheet1 data goes to sheet2 automaticaly ?

[ABDUSSALAM]

Hai all
I would like to know one excel sheet1 data to sheet2 automaticaly,which
command use for it ,please....

 

[Fred Smith]

It's a formula. If you're on sheet2, to reference sheet1, use something
like:
=sheet1!a1

Regards,
Fred

 

[Pete_UK]

If it's a one-off requirement you can just use copy/paste, but if you
want it to be dynamic then you can put this formula in A1 of sheet2:

=IF(sheet1!A1="","",sheet1!A1)

then just copy the formula across and down as required.

Hope this helps.

Pete