Add and rename sheets using vba

[Swann]

Query needed for add multiple sheets and rename them using VBA.

[NickyC]

this is very easy but a bit more information might make the response more useful eg how many sheets and what names.
This may get you started - it will add 6 sheets named MySheet1 to MySheet6 at the end of the active workbook

Please Login or Register  to view this content.

[Swann]

in the above query is useful but im in the need of rename the sheet name by existing values. Kindly give some query on the same

[NickyC]

Hi
sorry, I'm not sure what you mean by "rename the sheet name by existing values".
Are the sheet names stored in a range in the workbook? Or are the new sheets' names based on existing sheets' names?

[NickyC]

Hi Swann
i'm shortly logging off for the day but will try to visit this site tomorrow.
A variation that may be more useful is this: it creates new sheets and gives them the names in cells A1:A6 of the first sheet in the workbook.

Please Login or Register  to view this content.

[Swann]

Nicky,

Check and mentioned if you found any errors.

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[NickyC]

Hi Swann
sorry I am still not clear exactly what it is you are trying to do
your macro will rename sheets 1 to 5 as eg "base info" but the for ... next loop doesn't do anything, nor does your array. Are you hoping to add sheets new sheets with the names in your array? If so, try something like this:

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

Perhaps

Please Login or Register  to view this content.

[Swann]

Team,

After completing these sheets in workbook, have to give some inputs to every sheet.

Eg: In Base info sheet - name, address, ph no like that…

Give some ideas to create that.

[scottiex]

I think you should upload a file with the data you will enter and the result you want.

To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[Swann]

Find attached the input and output result for your reference. Kindly give the solution

[jindon]

Please Login or Register  to view this content.

[Swann]

it could't understand can you please explain this?

[jindon]

Explain what?

It is doing what you requested from your 2 files provided.

[Swann]

In that, can i declare my sheet names and their respected values in the coding itself?

if i declare in coding page it easier for understanding because am a newbie cant understand your code that's the reason i ask.

[jindon]

What do you really want to do?

By the way, do your country have some word to express appreciation when you received some help?

[Swann]

Forgot to say, thank you so much for your help....

[Swann]

Please Login or Register  to view this content.

Can you please explain this above statement?