Prev: Prevent dragging cell contents
Next: Macrs with Validation Rules
From: ABDUSSALAM on 10 Mar 2010 11:03
Hai all
I would like to know one excel sheet1 data to sheet2 automaticaly,which
command use for it ,please....
From: Fred Smith on 10 Mar 2010 11:08
It's a formula. If you're on sheet2, to reference sheet1, use something
like:
=sheet1!a1

Regards,
Fred

"ABDUSSALAM" <ABDUSSALAM(a)discussions.microsoft.com> wrote in message
news:9F5C2113-D186-41EA-9CEB-0D190D101F1B(a)microsoft.com...
> Hai all
> I would like to know one excel sheet1 data to sheet2 automaticaly,which
> command use for it ,please....

From: Pete_UK on 10 Mar 2010 11:12
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 <ABDUSSA...(a)discussions.microsoft.com>
wrote:
> Hai all
>  I would like to know one excel sheet1 data to sheet2 automaticaly,which
> command use for it ,please....

 | 
Pages: 1
Prev: Prevent dragging cell contents
Next: Macrs with Validation Rules