I have a spreadsheet that multiple users access and update multiple times per
month. At the end of the month, I would like to know what the values of
certain cells were for ongoing reporting and graphing. The values I want to
know are percentages, sums, etc.

I was hoping someone could help with a macro that executed itself at the end
of the month or if the sheet has to be open for it to be executed, a macro
that automatically captures this data the first time it's opened in a new
month.

Is there a cell function that could do this? I tried using a if/then
formula that captured the value on a given date but as soon as that date
passed, the value did not freeze indefinetly.

You need to write a macro in Workbook_Open()

To setup designate a cell to store the month number... macro can check that
to know whether it has run on the current month... if not then you can
collect the data you want... and then update the flag cell so that it does
not run again during the month...
--
--------
If this is what you wanted then press the ''''YES'''' button (if you see it)


"JeremyR." wrote:

> I have a spreadsheet that multiple users access and update multiple times per
> month. At the end of the month, I would like to know what the values of
> certain cells were for ongoing reporting and graphing. The values I want to
> know are percentages, sums, etc.
>
> I was hoping someone could help with a macro that executed itself at the end
> of the month or if the sheet has to be open for it to be executed, a macro
> that automatically captures this data the first time it's opened in a new
> month.
>
> Is there a cell function that could do this? I tried using a if/then
> formula that captured the value on a given date but as soon as that date
> passed, the value did not freeze indefinetly.
>