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 indirect 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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Preserve exact formula, monthly analysis for full year
At this point I can highlight everything, paste value to get rid of the formulatext like i did before.
I used your find and replace = to =. It worked
To give you an idea, just in this sheet alone i have 9 entities, 9 analytic for budget, 9 analytic for average, and 7 months left in the year.
You pretty much saved me from hitting F2 - Enter 1134 times. I also have 5 sheets in total. So approximately, F2-enter 5,000 times.
sheetspread, my hero
I used your find and replace = to =. It worked
To give you an idea, just in this sheet alone i have 9 entities, 9 analytic for budget, 9 analytic for average, and 7 months left in the year.
You pretty much saved me from hitting F2 - Enter 1134 times. I also have 5 sheets in total. So approximately, F2-enter 5,000 times.
sheetspread, my hero
Upvote
0
Excel Facts
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Similar threads
- Question
