Hi,
I would like to duplicate my current worksheet a lot of times. Now with every duplicate, i want to change 5 values by +10 every time a duplicate is made:
Every time a duplicate is made i want to change EXPORT1 to EXPORT11, EXPORT2 to EXPORT22 and so on...
EXPORT11 to EXPORT21 and EXPORT22 to 32 and so on....
Is there any way to do this a fast way? So that my input is 50 sheets (for example) and always have the EXPORT's +10 by every duplicate that is made?
Example.png
Maybe this can help you:
Cheers
Please Login or Register to view this content.
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Hi Erwin,
I think i gave you the wrong information. I would like to mass duplicate my sheets and not my worksheet (XLS file). Also i want to increase 5 values of cells by +10 every time a duplicate is made.
Could you help me with this? Would help me a lot.
Thanks
So you must be clear in your names, now you are making it more confusing. A workbook has 1 or more worksheets.
Right now I have made a macro for copying worksheets. What is the name of the workbook that you want to copy?
Cheers
Erwin
Hi Erwin,
Yes, my mistake. I'm sorry. I have found a macro for copying sheets. However, now i want to increase the value of 5 cells by +10 every time a duplicate is made. In the first sheet the values are EXPORT1, EXPORT2, EXPORT3, ..4, ..5 and in the second sheet the values must be EXPORT11, EXPORT12, ..13, ..14, ..15 and so on.
Please Login or Register to view this content.
maybe this is what you want: (I cannot read minds you know)
CheersPlease Login or Register to view this content.
Erwin
Erwin,
This is what i meant, Thanks! The only downside is that it overwrites the original sheet and uses it for the last copy. Is this on purpose?
Before run:
Attachment 672437
After run (copy 3 times):
Attachment 672438
I would like to keep the original and when my input is 3 copies, the second sheet should be 11-15, third one 21-25 and last one 31-35.
Sorry if you misunderstood me
If you go to the dutch section there you can write into dutch and upload a file with the file manager.
the attachments that you are tryiing to upload are not visible for me, you must upload them via the attachment manager.
Cheers
Erwin
There is no Dutch section - there is a non-English section. However, please do NOT take the conversation there. All you need to do is provide an English translation of your Dutch comments here (Google Translate will be good enough).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Coen, that is not on purpose,
I simply used your code, as you have changed mine.
I will make shortly a new macro. stay tuned
Cheers
Erwin
@Ali, sorry I did not know this. We will keep the conversation here.
I had to add only 1 line:
CheersPlease Login or Register to view this content.
Erwin
Hi,
I have no clue why, but it still uses the original sheet as the last one and places it in front of all the sheets.
Attachment 672643
And this is what it does:
Attachment 672644
Ha Coen, you must upload the picture-files with the attachment manager (Go advanced) , because for us they are not visible.
What do you want to happen with the original sheet? I must make copies of the original sheet, or not?
Cheers
Erwin
Erwin,
Thats weird, because for me they are visible, but okay, haha.
Please Login or Register to view this content.
I got it done with this code
Thanks a lot for helping
Hi Coen, if you make more copies, you might want to change this line and it's subsequents:
CheersPlease Login or Register to view this content.
Erwin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks