I am working on a ranking workbook. At the beginning of the season I rank a hole bunch of in information on a sheet. Once there ranked I want to lock in those number until the next year when I want to rank them again. How can I make this happen.
Thanks in advanced.
Perhaps a copy and paste special values somewhere else?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Formulas are not static, they calculate each time the sheet or workbook is calculated. If the result is the same, you perceive no change.
You can either turn off automatic calculation in which case the entire workbook doesnt update any formula until you manually update calculations (or if you have it set to calc on open/close) or you can do the other recommendation of replacing the formulas with the results via paste special. Paste special over the formulas removes them, leaving you with static results.
A third alternative is copy the results out to another sheet/workbook using paste special. Then you have a copy thats easy to update and a static copy that doesnt change.
A fourth more complex option I do NOT recommend is you could use VBA. Have a macro do the ranking and store the result (instead of the formula) in the cells on sheet. In this fashion it only updates when you run the code. It however will require saving as a macro, enabling macros, running the macro, fixing the macro when (not if) it breaks, etc.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks