I have a ton of data that gets updated every month, multiple spreadsheets, each with sometimes as many as 20,000 rows. I condense this down to a few Key Performance Indicators (KPI's) and convert it to graphs. The data for the graphs is always located on the same cell range every month and the type of graph wanted will always be the same. It takes quite a while to recreate these graphs every month and wish there was a way to automate the process via Visual Basic, Macros or something else, but I've never stepped into either of those worlds.
Creating the graphs would be step 1. Once I learn how to do that, step 2 would be to autogenerate or generate with a click of a button, a PDF of the graph.
Any suggestions, advice or direction to point me?
Thanks
Creating the graphs would be step 1. Once I learn how to do that, step 2 would be to autogenerate or generate with a click of a button, a PDF of the graph.
Any suggestions, advice or direction to point me?
Thanks