On May 5, 9:09*am, Ruth wrote:
Hi

I have a spreadsheet which is updated once a month by several other users,
on this spreadsheet i have a summary page which returns me the total number
of staff that need training. What I am looking to do is find a way that excel
will automatically store what the number of staff that need training is at
the beginning of every month. For example I am looking to have a table with
January - December with a numerical value next to each.

I know this seems like a simple fix by just copying and pasting once a month
but ideally i would excel to do it. Is this possible

Thanks in advance for your help
--
Thanks

Ruth

How is the data entered? What fields are stored with respect to the
time period?