copy from 1 sheet to another

[S]

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

 

[Peo Sjoblom]

What doesn't work?

 

[Don Guillett]

Try

=mergedcellsname

 

[Sandy Mann]

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[S]

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.

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

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?

--
Regards,

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[S]

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?

 

[Sandy Mann]

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

= 'Booking Form'!D6

--
HTH

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

(e-mail address removed)
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
=Booking '[Form]Booking Form'!D6
I get this reply #NAME?

can anyone help?

Yes D6 is the left-most cell.

 

[Peo Sjoblom]

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


--

Regards,

Peo Sjoblom

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

= 'Booking Form'!D6

--
HTH

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

(e-mail address removed)
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
=Booking '[Form]Booking Form'!D6
I get this reply #NAME?

can anyone help?

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.

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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

 

[S]

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,
select the cell, copy it and go to where you want the link and paste
special and select link


--

Regards,

Peo Sjoblom

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

= 'Booking Form'!D6

--
HTH

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

(e-mail address removed)
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
=Booking '[Form]Booking Form'!D6
I get this reply #NAME?

can anyone help?

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.

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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

 

[Peo Sjoblom]

It works fine if applied correctly



--

Regards,

Peo Sjoblom

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,
select the cell, copy it and go to where you want the link and paste
special and select link


--

Regards,

Peo Sjoblom

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

= 'Booking Form'!D6

--
HTH

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

(e-mail address removed)
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
=Booking '[Form]Booking Form'!D6
I get this reply #NAME?

can anyone help?

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.

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

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


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

 

[S]

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.