Re-create a form

[one_more_cave_dweller]

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:

 

[Smitty]

Sure.

If you copy your form, and add a Data-->Validation list for the date, you can use VLOOKUP in the 30 cells and reference the date in your summary sheet.

Hope that helps,

Smitty

 

[one_more_cave_dweller]

I'm sorry but I am very new to this, could you elaborate.

Thanks ray: