J
jlstraw
Hello all.
Ok, here is my delima. I have a workbook that has many worksheets. In the
end, it will probably have to be devided up because it will have at least 2
worksheets for each workday (Mon - Fri). Here is where it gets interesting.
I will try to make this as painless as possible.
I have 2 Templates. Template 1, and Template 2.
When the data for Jan 1 is ready to be entered, the user copies Template 1,
renames it (Jan 1), and then enters the data.
Then, Template 2 is copied, and renamed (jan1). The data for this sheet is
pulled from (Jan 1) worksheet. Presently, the user has to go over to the
(Jan 1) worksheet and copy-and-paste each item that is needed.
So, here is my question, in a few parts.
1
Can I create a button/macro that will copy Template 1, and ask the user
what they want to name it? And possibly, where they want to place it?
2 Is it possible to have this button/macro also create a copy of Template
2, also asking the user what to name it, and where to place it?
OK, at this point, the macro would copy both Template 1 and Template 2,
and ask the user what they wanted them named and where they wanted them
placed. If possible, I need a few more things done with the button/macro.
3 I know how to link cells in (jan1) and have them pull from (Jan 1). My
main question is: Can I have the macro, when it copies Template 1, and
Template 2 (and renames them Jan 1, and jan1) - can it also make the links in
jan1 now refer to Jan 1, in stead of Template 1? (I know if I just copy
Template 2, and rename it jan2 - the links in it will still refer to Template
1. Which is not what I need.) I don't want the end-user to have to go
through and update all the links manually. I also don't want them to have to
copy-and-paste all the information one-by-one.
I hope this makes sense. It does to me...but, that does not necessarily
mean anything.
Thanks for your input.
jlstraw
Ok, here is my delima. I have a workbook that has many worksheets. In the
end, it will probably have to be devided up because it will have at least 2
worksheets for each workday (Mon - Fri). Here is where it gets interesting.
I will try to make this as painless as possible.
I have 2 Templates. Template 1, and Template 2.
When the data for Jan 1 is ready to be entered, the user copies Template 1,
renames it (Jan 1), and then enters the data.
Then, Template 2 is copied, and renamed (jan1). The data for this sheet is
pulled from (Jan 1) worksheet. Presently, the user has to go over to the
(Jan 1) worksheet and copy-and-paste each item that is needed.
So, here is my question, in a few parts.
1
Can I create a button/macro that will copy Template 1, and ask the userwhat they want to name it? And possibly, where they want to place it?
2
Is it possible to have this button/macro also create a copy of Template2, also asking the user what to name it, and where to place it?
OK, at this point, the macro would copy both Template 1 and Template 2,
and ask the user what they wanted them named and where they wanted them
placed. If possible, I need a few more things done with the button/macro.
3
I know how to link cells in (jan1) and have them pull from (Jan 1). Mymain question is: Can I have the macro, when it copies Template 1, and
Template 2 (and renames them Jan 1, and jan1) - can it also make the links in
jan1 now refer to Jan 1, in stead of Template 1? (I know if I just copy
Template 2, and rename it jan2 - the links in it will still refer to Template
1. Which is not what I need.) I don't want the end-user to have to go
through and update all the links manually. I also don't want them to have to
copy-and-paste all the information one-by-one.
I hope this makes sense. It does to me...but, that does not necessarily
mean anything.
Thanks for your input.
jlstraw