copying data and then getting it back
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 |
copying data and then getting it back
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 |
All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com