[ASK]Copy/rename/hyperlink

[Blsgw]

Hi guys, im working on an excel workbook for work, and something that takes me seconds to do, takes other people minutes (far too long).

Here is what im trying to find how to do using VBA;

Copy sheet named: Template
Paste sheet at the end of all current sheets
Rename the new copied sheet to the value in "New Brand" C5
Copy the value in "New Brand" C5 and paste in A2 of the new sheet
Create a hyper-link to the new sheet in "Brands" B2 and the hyper-link text is to be the same as the sheet name (Value in "New Brand" C5)

Now the other thing to add is.. that I will be using this command many times... so when the hyper-link is made in "Brands B2" I want it to basically make the hyper-link after the last one that is in that column (so the first time it will create the hyper-link in B2, then the 2nd time its B3 etc)

So... is this at all possible??

Thanks in advance for any help you can give me :D

 

[bensonsearch]

Hi guys, im working on an excel workbook for work, and something that takes me seconds to do, takes other people minutes (far too long).

Here is what im trying to find how to do using VBA;

Copy sheet named: Template
Paste sheet at the end of all current sheets
Rename the new copied sheet to the value in "New Brand" C5
Copy the value in "New Brand" C5 and paste in A2 of the new sheet
Create a hyper-link to the new sheet in "Brands" B2 and the hyper-link text is to be the same as the sheet name (Value in "New Brand" C5)

Now the other thing to add is.. that I will be using this command many times... so when the hyper-link is made in "Brands B2" I want it to basically make the hyper-link after the last one that is in that column (so the first time it will create the hyper-link in B2, then the 2nd time its B3 etc)

So... is this at all possible??

Thanks in advance for any help you can give me :D

so with the first step you are "moving" or "copying" the sheet from position 1 to the end? does "New Brand" C5 ever change? if not the hyperlink will be the same over and over

 

[Blsgw]

Template is the sheet to be copied and "New Brand" C5 is where I would like to input the data to change the sheet name etc, so that is my value input cell, will change each time i perform the macro

EDIT: And its copying the sheet, not just moving it

 

[bensonsearch]

Template is the sheet to be copied and "New Brand" C5 is where I would like to input the data to change the sheet name etc, so that is my value input cell, will change each time i perform the macro

EDIT: And its copying the sheet, not just moving it

so template will be at the begining and the end? i take it the data will be filled out already? if so then all is doable

 

[Blsgw]

template is the 2nd sheet in the workbook, and as the name suggests, its just a blank template for the brands, the data in "new brand" c5 is going to be the name of the new brand I want to add. So the copied template sheet (which is now at the end of the workbook hopefully) should be re-named to "New Brand" C5 and a hyperlink created in "Brands" B2 linking to the new template sheet.. :D

Does that all make sense? :S

 

[Blsgw]

Bumping