copy from 1 sheet to another

's Computer Specifications

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 Computer Specifications

What doesn't work?

--

Regards,

Peo Sjoblom

"S" <(E-Mail Removed)> wrote in message
news:lqfJi.264519$(E-Mail Removed)...
> 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 Computer Specifications

Try

=mergedcellsname

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"S" <(E-Mail Removed)> wrote in message
news:lqfJi.264519$(E-Mail Removed)...
> 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 Computer Specifications

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 Removed)
Replace @mailinator.com with @tiscali.co.uk

"S" <(E-Mail Removed)> wrote in message
news:lqfJi.264519$(E-Mail Removed)...
> 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 Computer Specifications

Yes D6 is the left-most cell.

"Sandy Mann" <(E-Mail Removed)> wrote in message
news:ewHfBOW$(E-Mail Removed)...
> 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 Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "S" <(E-Mail Removed)> wrote in message
> news:lqfJi.264519$(E-Mail Removed)...
>> 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 Computer Specifications

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 Removed)
Replace @mailinator.com with @tiscali.co.uk

"S" <(E-Mail Removed)> wrote in message
news:UfpJi.691$(E-Mail Removed)...
> Yes D6 is the left-most cell.
>
> "Sandy Mann" <(E-Mail Removed)> wrote in message
> news:ewHfBOW$(E-Mail Removed)...
>> 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 Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "S" <(E-Mail Removed)> wrote in message
>> news:lqfJi.264519$(E-Mail Removed)...
>>> 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 Computer Specifications

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?

"S" <(E-Mail Removed)> wrote in message
news:UfpJi.691$(E-Mail Removed)...
> Yes D6 is the left-most cell.
>
> "Sandy Mann" <(E-Mail Removed)> wrote in message
> news:ewHfBOW$(E-Mail Removed)...
>> 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 Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "S" <(E-Mail Removed)> wrote in message
>> news:lqfJi.264519$(E-Mail Removed)...
>>> 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 Computer Specifications

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 Removed)
Replace @mailinator.com with @tiscali.co.uk

"S" <(E-Mail Removed)> wrote in message
news:cctJi.169253$(E-Mail Removed)...
> 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?
>
> "S" <(E-Mail Removed)> wrote in message
> news:UfpJi.691$(E-Mail Removed)...
>> Yes D6 is the left-most cell.
>>
>> "Sandy Mann" <(E-Mail Removed)> wrote in message
>> news:ewHfBOW$(E-Mail Removed)...
>>> 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 Removed)
>>> Replace @mailinator.com with @tiscali.co.uk
>>>
>>>
>>> "S" <(E-Mail Removed)> wrote in message
>>> news:lqfJi.264519$(E-Mail Removed)...
>>>> 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 Computer Specifications

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

"Sandy Mann" <(E-Mail Removed)> wrote in message
news:u%23cBkUe$(E-Mail Removed)...
>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 Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "S" <(E-Mail Removed)> wrote in message
> news:cctJi.169253$(E-Mail Removed)...
>> 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?
>>
>> "S" <(E-Mail Removed)> wrote in message
>> news:UfpJi.691$(E-Mail Removed)...
>>> Yes D6 is the left-most cell.
>>>
>>> "Sandy Mann" <(E-Mail Removed)> wrote in message
>>> news:ewHfBOW$(E-Mail Removed)...
>>>> 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 Removed)
>>>> Replace @mailinator.com with @tiscali.co.uk
>>>>
>>>>
>>>> "S" <(E-Mail Removed)> wrote in message
>>>> news:lqfJi.264519$(E-Mail Removed)...
>>>>> 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 Computer Specifications

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

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:O1PL61g$(E-Mail Removed)...
> 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
>
>
>
>
>
> "Sandy Mann" <(E-Mail Removed)> wrote in message
> news:u%23cBkUe$(E-Mail Removed)...
>>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 Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "S" <(E-Mail Removed)> wrote in message
>> news:cctJi.169253$(E-Mail Removed)...
>>> 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?
>>>
>>> "S" <(E-Mail Removed)> wrote in message
>>> news:UfpJi.691$(E-Mail Removed)...
>>>> Yes D6 is the left-most cell.
>>>>
>>>> "Sandy Mann" <(E-Mail Removed)> wrote in message
>>>> news:ewHfBOW$(E-Mail Removed)...
>>>>> 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 Removed)
>>>>> Replace @mailinator.com with @tiscali.co.uk
>>>>>
>>>>>
>>>>> "S" <(E-Mail Removed)> wrote in message
>>>>> news:lqfJi.264519$(E-Mail Removed)...
>>>>>> 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
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search for values in a sheet and copy found records one after theother in another sheet	AndreasHermle	Microsoft Excel Programming	12	17th Jun 2011 08:12 PM
Auto Copy/autofill Text from sheet to sheet if meets criteria	Joyce	Microsoft Excel Misc	0	20th Nov 2008 11:05 PM
Copy Paste from Class Sheet to Filtered List on Combined Sheet	prkhan56@gmail.com	Microsoft Excel Programming	6	16th Sep 2008 04:30 PM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.	bertbarndoor	Microsoft Excel Programming	4	5th Oct 2007 04:00 PM
relative sheet references ala sheet(-1)!B11 so I can copy a sheet.	=?Utf-8?B?Um9uTWM1?=	Microsoft Excel Misc	9	3rd Feb 2005 12:51 AM