Method 3 (pasting a formula into visible cells only) works perfectly. This will save me a lot of time and the hassle of accidentally pasting into hidden cells and overwriting other values. Multiple other "solutions" proposed on Microsoft support pages, TH-cam, reddit, etc were not working. This is a game changing solution to a problem that has been plaguing me.
Method 3 (pasting a formula into visible cells only) works perfectly. This will save me a lot of time and the hassle of accidentally pasting into hidden cells and overwriting other values. Multiple other "solutions" proposed on Microsoft support pages, TH-cam, reddit, etc were not working. This is a game changing solution to a problem that has been plaguing me.
Great to hear Gary! Please let me know if you experience any issues with the method and I can assist!
Excelent
Excelsior