Copying cell data and displaying it correctly

daveray · Apr 21st, 2002, 03:45 AM

I have a multi-sheet workbook and some of the correlating data appears on all of the sheets. Once I have entered it on the opening sheet I want it automatically copied to the other sheets. It works on some cells but not on others.

Customer name is on the first sheet called 'Customer Details' and when I copy it across to the subsequent sheet using ='customer details'!E1 it works in some cells but in others I simply get ='customer details'!E1

Can someone help me with this please?

Many thanks

Dave

Paul B · Apr 21st, 2002, 06:51 AM

Sounds like the cells where you are getting ='customer details'!E1 are formatted as text

dpolson · Apr 21st, 2002, 07:04 AM

I tried to reproduce this, and the only way I could get what you describe is if I put a ' in fromt of the ='customer details'!E1 like this:

'=customer details'!E1

I don't know if that is the problem, but it might be worth checking out.

Dale

Chris Davison · Apr 21st, 2002, 07:10 AM

maybe your subsequent sheet has CNTRL and ` toggled to show formulae.... try going to your subsequent sheet and hitting CNTRL and `

(the "`" is left of the "1" key, top left)

daveray · Apr 21st, 2002, 07:54 AM

I have the ' in the correct place and the CNTRL ` doesn't help?

I really am puzzled

smozgur · Apr 21st, 2002, 08:13 AM

PaulB is right i think

Related cell is formatted as Text. You can set it as General and activate it by F2 then press enter. You would see it has changed to formula.

daveray · Apr 21st, 2002, 01:26 PM

You were 100% correct, the relative cell was formatted as Text. I looked at that but totally missed it.

Thanks all

Dave

Apr 21st, 2002, 07:10 AM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	maybe your subsequent sheet has CNTRL and ` toggled to show formulae.... try going to your subsequent sheet and hitting CNTRL and ` (the "`" is left of the "1" key, top left) __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 21st, 2002, 03:45 AM	#1
daveray New Member Join Date: Mar 2002 Posts: 28	I have a multi-sheet workbook and some of the correlating data appears on all of the sheets. Once I have entered it on the opening sheet I want it automatically copied to the other sheets. It works on some cells but not on others. Customer name is on the first sheet called 'Customer Details' and when I copy it across to the subsequent sheet using ='customer details'!E1 it works in some cells but in others I simply get ='customer details'!E1 Can someone help me with this please? Many thanks Dave

Apr 21st, 2002, 06:51 AM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Sounds like the cells where you are getting ='customer details'!E1 are formatted as text

Apr 21st, 2002, 07:04 AM	#3
dpolson New Member Join Date: Apr 2002 Posts: 17	I tried to reproduce this, and the only way I could get what you describe is if I put a ' in fromt of the ='customer details'!E1 like this: '=customer details'!E1 I don't know if that is the problem, but it might be worth checking out. Dale

Apr 21st, 2002, 07:54 AM	#5
daveray New Member Join Date: Mar 2002 Posts: 28	I have the ' in the correct place and the CNTRL ` doesn't help? I really am puzzled

Apr 21st, 2002, 08:13 AM	#6
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	PaulB is right i think Related cell is formatted as Text. You can set it as General and activate it by F2 then press enter. You would see it has changed to formula.

Apr 21st, 2002, 01:26 PM	#7
daveray New Member Join Date: Mar 2002 Posts: 28	You were 100% correct, the relative cell was formatted as Text. I looked at that but totally missed it. Thanks all Dave