how to sheet1 data goes to sheet2 automaticaly ?

  • Thread starter Thread starter ABDUSSALAM
  • Start date Start date
A

ABDUSSALAM

Hai all
I would like to know one excel sheet1 data to sheet2 automaticaly,which
command use for it ,please....
 
It's a formula. If you're on sheet2, to reference sheet1, use something
like:
=sheet1!a1

Regards,
Fred
 
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
 
Back
Top