copying data and then getting it back

[Gwyndaffandy]

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

 

[Don Guillett]

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.