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