Automatically changing parts of plain text
Hi there, I've decided I want to start optimizing small bits and pieces of my day to day work sheets, but I'm not super savvy so hoping someone can help me figure out if there is some neat way to do this:
I do a monthly report on my company's bookkeeping that compares to budget and how we did the previous year. This currently requires me to manually go in and edit text in like 6 different cells to whatever the month the report is for, and I often find myself missing one because it's manual. I have at this point already made a dropdown that changes which part of the year's budget is taken into account, and I figure I *could* use that same dropdown to work around this by making an index/match function and making a hidden sheet with the text I need for different months, but it feels a little clunky and too "brute force" of a method. Is there any better way to do this?
I've attached an image of the text that needs to be changed every month
[link] [comments]
Want to read more?
Check out the full article on the original site