+ Reply to Thread
Results 1 to 6 of 6

Copy from one list to multiple sheets with different values for each sheet + renaming

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Paris, France
    MS-Off Ver
    MS Office 2007
    Posts
    4

    Copy from one list to multiple sheets with different values for each sheet + renaming

    Hello.

    I have a question. I have 501 sheets in one excel file. Every sheet represent an article. Last sheet #501 have a list of article number with different weeks when they will be sold. I have to put an artticle code at every single sheet from the list and rename this sheet by the name opf article. SO for instance I have such sheet #501 (last one)
    article number / week
    200005 08
    654654 09
    123123 08
    111222 04
    555888 08

    So I want to do a week 8. So as result I have to have a name of the tab "200005" instead "tab1" and to have in a cell A6 the numver 20005
    the tab2 will be 123123 and will have 123123 in A6. And so on.

    Can you help me to solve the problem?

    P.S. The renaming feature I did from here by VBA code (because the list of articles is on another separate sheet), but it is a bit bugged and have mistake message (but nevertheless does its job).

    Thank you in advance!

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,137

    Re: Copy from one list to multiple sheets with different values for each sheet + renaming

    Hi

    Are you saying that the workbook has all the sheets already ?

    or do you want to create the sheets using the list in page 501?

    I can do that very easily and more. to make your workbook manageable.


    But I am sure you have made a mistake.

    Why have the tab name in A6? Pointless. did you mean the Article week No?

    How user freindly is a workbook with 500 pages?
    Attached Files Attached Files
    Last edited by mehmetcik; 12-17-2014 at 07:51 PM.
    My Rules if you want my help:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    12-17-2014
    Location
    Paris, France
    MS-Off Ver
    MS Office 2007
    Posts
    4

    Re: Copy from one list to multiple sheets with different values for each sheet + renaming

    yes, i have an empty etalon with all sheets inside already, I guess someone clever did it for me already before hehe. Well not 500, about 100, it was just an example ( but not far from the truth also hehe)
    A6 is not the name of the sheet, it is a cell where I have to put an article number. Sorry, I guess I was not enough clear due to me bad English.
    Yes, the list with all articles and week numbers already ready and in fact it is another file. But to make the operation possible I have to copy and paste it in my file with 500 sheets in end to have a source of article codes.
    Last edited by Thifiell; 12-18-2014 at 02:48 PM.

  4. #4
    Registered User
    Join Date
    12-17-2014
    Location
    Paris, France
    MS-Off Ver
    MS Office 2007
    Posts
    4

    Re: Copy from one list to multiple sheets with different values for each sheet + renaming

    The file is corrupted a bit..."Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
    Removed Records: Sorting from /xl/worksheets/sheet1.xml part". But I have opened it and tried it, thank you!

    Thank you for trying to help me, but I can just add a VBA code to the macros because I cannot change an sample docs with my own form. So the only thing I can do is to create a macros for this. That is why I will be very greateful for a VBA code.

    I upload a doc to show how does it look. first 3 sheets are not renamed and empty, so this is what do I have. 4th sheet is this the last sheet with list of srticles from where I have to take all codes of article. ANd next 3 sheets are the result (sorted by week 5) I expecting to have. Hope it will help....week 5.xlsx

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy from one list to multiple sheets with different values for each sheet + renaming

    Maybe:

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-17-2014
    Location
    Paris, France
    MS-Off Ver
    MS Office 2007
    Posts
    4

    Re: Copy from one list to multiple sheets with different values for each sheet + renaming

    That is a very good thing, but there are some problems. I do not need to create new tabs after the last one.

    The best variant would be with messages "choose the list of the codes of article" and "choose the cell where to put the code of article". This question system was realized very good here with row comparation. And after the macros has to edit all tabs from the first one untill the end of the selected list after the 1`question with renaming of them accordingly with their article number. Thank you for help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using VBA to copy multiple sheets as values to another sheet
    By Excel15 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2014, 09:44 AM
  2. Renaming multiple tabs from a list in sheet 1
    By 2Quick2Fast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 12:10 PM
  3. Data copy and paste to multiple sheets by renaming the names
    By Ignesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2012, 02:37 PM
  4. Search for Multiple String Values on Multiple Sheets and Copy Rows to New Sheet
    By rrtikker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 12:21 PM
  5. [SOLVED] Renaming sheets from a list
    By Max in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1