Forum Discussion

Krisje65's avatar
Krisje65
Copper Contributor
Jun 29, 2020

link to cel in another tab in the same workbook

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 cor...
excel
ExcelExciting's avatar
ExcelExciting
MVP
Jun 29, 2020

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

 

Krisje65's avatar
Krisje65
Copper Contributor
Jun 30, 2020

ExcelExciting  

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.

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Jul 01, 2020

    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

    • Krisje65's avatar
      Krisje65
      Copper Contributor
      Jul 03, 2020

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