copy from 1 sheet to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S - 22 Sep 2007 22:03 GMT

Cant understand this

This works from sheet1 to sheet`invoice` =Sheet1!J28 (this is a number)
But this doesnt from sheet 1 to sheet`invoice` =Sheet1!D6 (this has
cells merged and is a name)

Any ideas.
thanks

Reply to this Message

Peo Sjoblom - 22 Sep 2007 22:14 GMT

What doesn't work?

Signature

Regards,

Peo Sjoblom

> Cant understand this
>
[quoted text clipped - 5 lines]
> Any ideas.
> thanks

Reply to this Message

Don Guillett - 22 Sep 2007 22:15 GMT

Try

=mergedcellsname

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Cant understand this
>
[quoted text clipped - 5 lines]
> Any ideas.
> thanks

Reply to this Message

Sandy Mann - 22 Sep 2007 22:56 GMT

Is D6 the left-most cell in the merged cells? If it is not then you should
get 0 returned.

By the way Merged Cells is not a good idea for various reasons. It is much
better to select the range of cells that you want to centre the text, (or
number), on and select Format > Cells > Alignment > Horizontal > Center
Across Selection

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Cant understand this
>
[quoted text clipped - 5 lines]
> Any ideas.
> thanks

Reply to this Message

S - 23 Sep 2007 09:14 GMT

Yes D6 is the left-most cell.

> Is D6 the left-most cell in the merged cells? If it is not then you should
> get 0 returned.
[quoted text clipped - 13 lines]
>> Any ideas.
>> thanks

Reply to this Message

Sandy Mann - 23 Sep 2007 12:05 GMT

What does it return then? Nothing? #REF!?

What happens if you change the name to a number?

What is the format of the receiving cell?

Signature

Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Yes D6 is the left-most cell.
>
[quoted text clipped - 15 lines]
>>> Any ideas.
>>> thanks

Reply to this Message

S - 23 Sep 2007 13:43 GMT

Ok still trying to work this out.
I have entered this on 2nd sheet referenced to cell in 1st sheet
=Booking '[Form]Booking Form'!D6
I get this reply #NAME?

can anyone help?

> Yes D6 is the left-most cell.
>
[quoted text clipped - 15 lines]
>>> Any ideas.
>>> thanks

Reply to this Message

Sandy Mann - 23 Sep 2007 14:24 GMT

I assume that the sheet name is Booking Form. If it is try:

= 'Booking Form'!D6

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> Ok still trying to work this out.
> I have entered this on 2nd sheet referenced to cell in 1st sheet
[quoted text clipped - 22 lines]
>>>> Any ideas.
>>>> thanks

Reply to this Message

Peo Sjoblom - 23 Sep 2007 19:12 GMT

Or easier just type = then select the cell with the mouse click and press
enter and Excel will do the necessary arrangements. Or even easier, select
the cell, copy it and go to where you want the link and paste special and
select link

Signature

Regards,

Peo Sjoblom

>I assume that the sheet name is Booking Form. If it is try:
>
[quoted text clipped - 26 lines]
>>>>> Any ideas.
>>>>> thanks

Reply to this Message

S - 23 Sep 2007 21:01 GMT

That didnt work states an invalid reference to an external worksheet.

> Or easier just type = then select the cell with the mouse click and press
> enter and Excel will do the necessary arrangements. Or even easier,
[quoted text clipped - 31 lines]
>>>>>> Any ideas.
>>>>>> thanks

Reply to this Message

Peo Sjoblom - 23 Sep 2007 23:05 GMT

It works fine if applied correctly

Signature

Regards,

Peo Sjoblom

> That didnt work states an invalid reference to an external worksheet.
>
[quoted text clipped - 33 lines]
>>>>>>> Any ideas.
>>>>>>> thanks

Reply to this Message

S - 24 Sep 2007 18:10 GMT

I got it sorted. I deleted one sheet and started again, one issue that I
think was causing problems were the 2 cells concerned had different formats
so put both to general and it started working.
I put = sign in one cell then went to the other sheet clicked on cell to be
copied and pressed enter this now work, and its all running smoothly. Where
merged cells were involved I just backspaced (in the formula bar) so it was
copying just the left most cell.

Thanks for all the help and guidance on this.

> Is D6 the left-most cell in the merged cells? If it is not then you should
> get 0 returned.
[quoted text clipped - 13 lines]
>> Any ideas.
>> thanks

Reply to this Message