Hi everyone,
Thanks for all your help in the past (I've lurked).
I have written a SUMIF formula in a cell, D10, and I want to copy the formula to an adjacent cell, C10. When I copy the formula to C10, I want the result to be in the format that C10 was in before the format paint. Essentially, I want to lock certain aspects of the format in cell C10, but still copy the formula from D10. Please see below:
excel_formatpaint.JPG
Please let me know if I can give more of a description! I am macro-friendly though not well-versed.
SF1
Bookmarks