how to sheet1 data goes to sheet2 automaticaly ?
 

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

how to sheet1 data goes to sheet2 automaticaly ?
 

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

Regards,
Fred

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

how to sheet1 data goes to sheet2 automaticaly ?
 

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

On Mar 10, 4:03*pm, ABDUSSALAM
wrote:
Hai all
*I would like to know one excel sheet1 data to sheet2 automaticaly,which
command use for it ,please....