ChatterBank18 mins ago
excel
basically i have multiply sheets/ pages on excel, at the moment i have to enter identical infomation on to each sheet.
i know how to have numbers linked from page to page.
eg, page 1, c3 equals page 2 f7.
but is there a way to do it with letters.
so if i had a code of a order being pb089-125
is there a way of the cell on the other page showing the same, rather than zero like it currently does if i try to "=sum( what ever cell with text in)"
hope you can help thanks in advance....
i know how to have numbers linked from page to page.
eg, page 1, c3 equals page 2 f7.
but is there a way to do it with letters.
so if i had a code of a order being pb089-125
is there a way of the cell on the other page showing the same, rather than zero like it currently does if i try to "=sum( what ever cell with text in)"
hope you can help thanks in advance....
Answers
Best Answer
No best answer has yet been selected by jazz1991. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.