one_more_cave_dweller
Board Regular
- Joined
- Sep 27, 2004
- Messages
- 118
I have a form filled out daily with approximately 30 cells spread out all over the sheet. I have a macro that copies each days information to another spreadsheet horizontally (i.e. cell a1 =1/1/05 and the information for that day is in the next 30 columns on row 1). Is it possible to create a sheet that the user could choose a date (maybe from a drop down menu) and have a macro copy and paste the information for that day into a blank form, thus re-creating that days form.
Thanks ray:
Thanks ray: