The basic idea is to use a macro to copy the data to the next available row
in another location. Then, another macro that asks for the month and brings
the data to wherever you want it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gwyndaffandy" wrote in message
...
Hi,

I have a spreadsheet that has a section for commentary on it. the
spreadsheet allows a user to select a specific month and the numbers will
come back for the specified month. there is then a space for commentary.
the
user updates this section with relevant explanations.
What i am trying to do is find a way that takes the data the user has
input,
saves it to another worksheet and then allows the data to be retrieved
when
that month is selected in the future.
hope this makes sense.
I am using 2003.

thanks in advance