Re: How to use indirect formula to show value AND formatting?
Hello Carissa,
Attached is a tiny modification ... :wink:
Hope this will help
Re: How to use indirect formula to show value AND formatting?
Hello Carissa,
Attached is a tiny modification ... :wink:
Hope this will help
Re: How to use indirect formula to show value AND formatting?
Quote from Carim;795233Hello 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:
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;795240Have 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
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:
Don’t have an account yet? Register yourself now and be a part of our community!