motherteresa
Board Regular
- Joined
- Nov 11, 2010
- Messages
- 76
I have a workbook with 3 worksheets in it. Each worksheet needs a various number of duplicate pages. In other words, the info on the page is like a template that needs to be copied downward. The page contains formulas and a macro attached to a button.
I have the Workbook created, with 1 page in each of those 3 worksheets. Our school consultants will then use their copy of the workbook and, depending on the client's needs, will need each worksheet's page copied and pasted a number of times. For example:
Ann needs
Wrksht 1 - 10 pages
Wrksht 2 - 15 pages
Wrksht 3 - 7 pages
Sue needs
Wrksht 1 - 30 pages
Wrksht 2 - 35 pages
Wrksht 3 - 15 pages
I could just create, say, 50 pages in each worksheet and then distribute the workbook to each consultant. But I was wondering if a macro could be written to copy everything on a page and then paste it x number of times...x being somehow defined by the user for each case.
So, for worksheet 1, the macro would copy rows 1-42 and then paste it to cell A43, A85, A127 and so on depending on how many copies were needed. This macro would be attached to a form(?) where a number indicating the number of copies desired could be input.
Thanks for any help. Hope I've explained it thoroughly enough.
I have the Workbook created, with 1 page in each of those 3 worksheets. Our school consultants will then use their copy of the workbook and, depending on the client's needs, will need each worksheet's page copied and pasted a number of times. For example:
Ann needs
Wrksht 1 - 10 pages
Wrksht 2 - 15 pages
Wrksht 3 - 7 pages
Sue needs
Wrksht 1 - 30 pages
Wrksht 2 - 35 pages
Wrksht 3 - 15 pages
I could just create, say, 50 pages in each worksheet and then distribute the workbook to each consultant. But I was wondering if a macro could be written to copy everything on a page and then paste it x number of times...x being somehow defined by the user for each case.
So, for worksheet 1, the macro would copy rows 1-42 and then paste it to cell A43, A85, A127 and so on depending on how many copies were needed. This macro would be attached to a form(?) where a number indicating the number of copies desired could be input.
Thanks for any help. Hope I've explained it thoroughly enough.