How to use indirect formula to show value AND formatting?

  • Re: How to use indirect formula to show value AND formatting?


    Hello Carissa,


    Attached is a tiny modification ... :wink:


    Hope this will help

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Re: How to use indirect formula to show value AND formatting?


    Your sample workbook looks empty ...


    Make sure you are using your original workbook with data in the Source worksheets ...


    Cheers


    :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Re: How to use indirect formula to show value AND formatting?


    Have added some data in Column A ... for tests ... and aligned sheet numbering ... to be on the safe side ...


    Cheers


    :smile:

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Re: How to use indirect formula to show value AND formatting?


    Quote from Carim;795240

    Have added some data in Column A ... for tests ... and aligned sheet numbering ... to be on the safe side ...


    Cheers


    :smile:


    Finally.. I kept getting error regarding colLtr. Apparently I didn't see the module *sigh*


    I cannot thank you enough really. You've helped me and I really appreciate your time, understanding, patience, and attention.


    I can't emphasize this enough but THANK YOU <3

  • Re: How to use indirect formula to show value AND formatting?


    Pleased to hear the code is now correctly adapted to your original workbook ...:smile:


    Thanks a lot ... for your very nice words ... :wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)