Related Posts
Additional Posts in Excel Genius
Best pdf to excel converter?
What are the most typical models you all build
Google Sheets vs Excel - pros? cons? differences?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Streamline the process. Have the same template for whoever you need the forecast from, put them in a Sharepoint w/ individual permissions, have them fill the file out, then powerquery it up.
I would second this solution. I'm doing the exact same thing as I work on my team's piece of next year's plan.
If you're not going to take the PowerQuery route, I would set the template up exactly in the same order that you would apply it to in your model. It makes things a ton easier when copying and pasting the data in.
Try to automate using VBA macros. But if you have to be told that than you probably face a steap learning curve.
Another option might be SQL. Is the data available in a data warehouse? If so then what you want may be just a quick “select”statement away.
Newer versions of Excel feature Power Query, which can do a lot with an easier learning curve than VBA.
love it! got 15min to chat in the next couple of days?
How do you collect them from each department today? What are the two or three most painful steps in the process?
Alteryx or Knime can help as well.
do u use them?
PM1 & VP1: this is the way.
Automate as much as you can then invest your time savings in leveling up your skills