Generating Multiple Pages with Different Names

[Deemed Offensive]

This workbook contains two sheets. List of items is in column A of sheet 1. It is necessary to copy each of these items into sheet 2's Cell C1. i.e., there are 120 items in column A of sheet 1, thus I'll need 120 sheets of sheet 2 with separate sheet names for each item, and those item names will go in cell C1 for each individual sheet.

Any help will be greatly appreciated. Thanks.

[AliGW]

You'll need VBA for this, so I've moved your thread.

[mohadin]

Hi
Try

Please Login or Register  to view this content.

[Deemed Offensive]

Hello Mohadin thanks for the reply, please see the attached jpeg file. I have encountered error 400. Please advise thanks.Attachment 797773

[Deemed Offensive]

The below code worked for me which was shared by p45cal Super Moderator on forums.excelguru.ca

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 it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://forums.excelguru.ca/threads/...t-names.11606/ )

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.