ryanmarshall101
New Member
- Joined
- Jul 10, 2012
- Messages
- 1
All
I hope you can help.
I want to create something which is beyond my knowledge but am a very fast learner.
I have a workbook which contains 3 surveys for the user to fill in. Once complete they run a MACRO which produces 6 reports on seperate worksheets based on their results.
I want to add a macro via the home page which will:
1. produce a message box where the user can select which reports (Worksheets) they want to keep.
2. allows them to select a file outside of this workbook that they already have saved.
3. once the above (1and2) have been selected all reports that have been selected in (1) will copy and pasted to the (2) document at the end of any previous sheets that exisit.
Regards
Ryanmarshall101
I hope you can help.
I want to create something which is beyond my knowledge but am a very fast learner.
I have a workbook which contains 3 surveys for the user to fill in. Once complete they run a MACRO which produces 6 reports on seperate worksheets based on their results.
I want to add a macro via the home page which will:
1. produce a message box where the user can select which reports (Worksheets) they want to keep.
2. allows them to select a file outside of this workbook that they already have saved.
3. once the above (1and2) have been selected all reports that have been selected in (1) will copy and pasted to the (2) document at the end of any previous sheets that exisit.
Regards
Ryanmarshall101