Sandler
05-25-2016, 10:19 AM
On a monthly basis, I run an analysis on a few entities based on certain criteria. To speed up the process, the analysis is driven by formula from the separate analysis tabs. This month I would create a May analysis driven by formulas. Above the May I have the same exact analysis tables for June-December (December being very top). After analysis is completed i can simply copy, paste value May. What’s the quickest way to copy the May formulas to June through December. I previously used the formulatext function, which was better than nothing, but there has to be an even faster way for Excel to know that I want to preserve the same exact formulas.