Hello again all,
I've been working on the same userform spreadsheet for sometime and now its onto the next hurdle which is to generate a monthly report.
The idea I've kind of pictured out in my head is to pull data from one sheet -> calculate the max/min/avg values for the month -> create charts for each section undecided if it should either be a line/bar/area chart atm but it will depend on the data -> finally it would be exported to a PDF and this would all be done clicking a button.
Coding wise I'm not sure how its going to be done but I already know that I'll likely need 1-2 variables for worksheets and a few last row variables and maybe more.
I've been working on the same userform spreadsheet for sometime and now its onto the next hurdle which is to generate a monthly report.
The idea I've kind of pictured out in my head is to pull data from one sheet -> calculate the max/min/avg values for the month -> create charts for each section undecided if it should either be a line/bar/area chart atm but it will depend on the data -> finally it would be exported to a PDF and this would all be done clicking a button.
Coding wise I'm not sure how its going to be done but I already know that I'll likely need 1-2 variables for worksheets and a few last row variables and maybe more.