J
JeremyR.
I have a spreadsheet in which mutiple people enter data into a spreadsheet.
On one tab, I have a overall results page that gives totals, percentages,
etc. on a right-now basis. If I go and mark something as complete for
example on one of my tabs, the results automatically update.
At the beginning of each month, several values in spreadsheets that
contribute to these calculations will calculate as "past due" automatically
based upon formula results in those spreadsheets.
What I want to do is take the results in cells (E4:E8) on the 27th of each
month and paste them as frozen values in a table below (Cells depend on
month). That will allow me to create an automatically updating chart showing
month to month results totals etc.
However, I do not always have the spreadsheet open on the 27th of each
month so I need this code to run even if the excel sheet is not opened. Is
this possible?
On one tab, I have a overall results page that gives totals, percentages,
etc. on a right-now basis. If I go and mark something as complete for
example on one of my tabs, the results automatically update.
At the beginning of each month, several values in spreadsheets that
contribute to these calculations will calculate as "past due" automatically
based upon formula results in those spreadsheets.
What I want to do is take the results in cells (E4:E8) on the 27th of each
month and paste them as frozen values in a table below (Cells depend on
month). That will allow me to create an automatically updating chart showing
month to month results totals etc.
However, I do not always have the spreadsheet open on the 27th of each
month so I need this code to run even if the excel sheet is not opened. Is
this possible?