link to cel in another tab in the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1495771%22%20slang%3D%22en-US%22%3Elink%20to%20cel%20in%20another%20tab%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495771%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20workbook%20in%20wich%20I%20use%20the%20next%20formula%20in%20the%20tab%20(worksheet)%20ACTION%3A%3C%2FP%3E%3CP%3EI%20want%20to%20see%20the%20content%20of%20some%20cels%20from%20other%20tabs%20(worksheets).%3C%2FP%3E%3CP%3EWhen%20i%20use%3A%3CBR%20%2F%3E%3DInfront!C18%26nbsp%3B%20%26gt%3B%26gt%3B%20this%20one%20works%20correct%20and%20shows%20the%20content%20of%20cel%20C18%20in%20the%20tab%20Infront%3C%2FP%3E%3CP%3E%3DInfront!B18%26nbsp%3B%20%26gt%3B%26gt%3B%20this%20one%20does%20not%20work%2C%20it%20shows%20the%20text%26nbsp%3B%20%26nbsp%3B%3CSTRONG%3E%3DInfront!B18%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3Eas%20content%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20tried%20changing%20the%20properties%20of%20the%20cel(s)%20from%20text%20to%20standard%20but%20that%20does%20not%20solve%20it.%3C%2FP%3E%3CP%3EI%20really%20do%20not%20understand%20why%20this%20happens.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495771%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495808%22%20slang%3D%22en-US%22%3ERe%3A%20link%20to%20cel%20in%20another%20tab%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495808%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713192%22%20target%3D%22_blank%22%3E%40Krisje65%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20please%20attached%20the%20sample%20screenshot%20or%20the%20file%20to%20assist%20you%20on%20your%20query%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1500727%22%20slang%3D%22en-US%22%3ERe%3A%20link%20to%20cel%20in%20another%20tab%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1500727%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20coloms%20%3CSTRONG%3EWerknemer%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EContractduur%20maanden%3C%2FSTRONG%3E%20should%20be%20the%20content%20of%20the%20cells%20I%20refered%20to.%3CBR%20%2F%3EThe%20other%20cells%20do%20show%20the%20content%20of%20the%20cells%20I%20refered%20to.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1502492%22%20slang%3D%22en-US%22%3ERe%3A%20link%20to%20cel%20in%20another%20tab%20in%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502492%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713192%22%20target%3D%22_blank%22%3E%40Krisje65%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20your%20formula%20might%20have%20leading%20or%20trailing%20spaces..%20can%20you%20please%20attach%20the%20file%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a workbook in wich I use the next formula in the tab (worksheet) ACTION:

I want to see the content of some cels from other tabs (worksheets).

When i use:
=Infront!C18  >> this one works correct and shows the content of cel C18 in the tab Infront

=Infront!B18  >> this one does not work, it shows the text   =Infront!B18  as content


I tried changing the properties of the cel(s) from text to standard but that does not solve it.

I really do not understand why this happens.

4 Replies

Hi @Krisje65,

 

Could you please attached the sample screenshot or the file to assist you on your query 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

 

@Faraz Shaikh  

In coloms Werknemer and Contractduur maanden should be the content of the cells I refered to.
The other cells do show the content of the cells I refered to.

Hi @Krisje65

 

I think your formula might have leading or trailing spaces.. can you please attach the file 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

@Faraz Shaikh I can't send you the file completely because of confidential information. I removed this tab and copied and modified another working tab. So the file is now working again. Thank you for your effort.