USING 5.6 ?? HOW CAN I LINK A DATA ITEM C10 SHEET 10 TO SHEET 1 DATA ITEM A5???
NOW WHEN I CREAT A NEW SHEET AND COPY SHEET 10 TO SHEET 11 ALL LINKS ARE NOT SHOWING. THE REFERANCE TO SHEET ON IS NOT USED.
Hi @The Hampton, Electronic messages written in all-caps are generally interpreted AS SHOUTING. Please refrain from shouting on the Ask site. Thanks!
In Sheet1.A5: =Sheet10.C10
A clear tutorial about Absolute and Relative references:
http://forum.openoffice.org/en/forum/viewtopic.php?f=75&t=2443
Using Named Ranges will allow you to copy a sheet and retain the correct references.
On sheet 1 click cell A5. In the Name Box (to the left of the Function Wizard), type the name you want to use to reference this data item. I’ll use DataItem5 as an example name. Now go to sheet 10 and select cell C10. Enter the formula:
=DataItem5
and press Enter. Now create sheet 11. Copy the contents of sheet 10 and paste them into sheet 11. Cell C10 on sheet 11 will now show the contents of sheet 1 cell A5.
Remember to give each data item on sheet 1 a different name.