Copying cell data and displaying it correctly

daveray

New Member
Joined
Mar 3, 2002
Messages
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
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sounds like the cells where you are getting ='customer details'!E1 are formatted as text
 
Upvote 0
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
 
Upvote 0
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)
 
Upvote 0
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.
 
Upvote 0
You were 100% correct, the relative cell was formatted as Text. I looked at that but totally missed it.

Thanks all

Dave
 
Upvote 0

Forum statistics

Threads
1,213,504
Messages
6,114,020
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top