Prev: How can i auto hide and display row or collum for zero value
Next: Sort messes up pictures
From: Khalid A. Al-Otaibi on 23 Mar 2010 00:37
Good day;

First of all, I would like to thank you. You helped so many times.

Example;;;

Sheet-1, Cell A1 = Milk

Sheet-2, Cell B1 = Can I copy the Cell [Sheet-1, Cell A1],?

The word (Milk) will appear'!
From: FSt1 on 23 Mar 2010 00:58
hi
not entirely sure what you mean but see if this is what you want...
on sheet 2 cell B1, enter
=sheet1!A1
what ever is in cell A1 on sheet 1 will appear in Cell B1 on sheet 2

Regards
FSt1

"Khalid A. Al-Otaibi" wrote:

> Good day;
>
> First of all, I would like to thank you. You helped so many times.
>
> Example;;;
>
> Sheet-1, Cell A1 = Milk
>
> Sheet-2, Cell B1 = Can I copy the Cell [Sheet-1, Cell A1],?
>
> The word (Milk) will appear'!
From: Khalid A. Al-Otaibi on 23 Mar 2010 01:10
Thank you so much, this is the second time you help me in.

That exactly what I want;

But one final question; Can I Copy the Formula also.

From: Khalid A. Al-Otaibi on 23 Mar 2010 01:14

Sorry, i ment the format


"Khalid A. Al-Otaibi" wrote:

> Thank you so much, this is the second time you help me in.
>
> That exactly what I want;
>
> But one final question; Can I Copy the Formula also.
>
From: Dave Peterson on 23 Mar 2010 08:00
Formulas don't work that way. They return values--not formats.

Khalid A. Al-Otaibi wrote:
>
> Sorry, i ment the format
>
> "Khalid A. Al-Otaibi" wrote:
>
> > Thank you so much, this is the second time you help me in.
> >
> > That exactly what I want;
> >
> > But one final question; Can I Copy the Formula also.
> >

--

Dave Peterson
 | 
Pages: 1
Prev: How can i auto hide and display row or collum for zero value
Next: Sort messes up pictures