How to use indirect formula to show value AND formatting?

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


    Quote from Carim;795233

    Hello Carissa,


    Attached is a tiny modification ... :wink:


    Hope this will help


    Hey, it's not copying :(
    What should I do?

    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 "Smiley" icon, below, in the bottom right corner :)

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


    It's not empty at all.. If you scroll down up to row 90, lots of data.


    So sorry to burden you with my incompetence :(((

    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:

    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 "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login