Macro to create separate files from main file

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Macro to create separate files from main file

  1. #1
    New Member
    Join Date
    May 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Macro to create separate files from main file

     
    Hi Everyone,

    Can anyone of you please provide a macro to create separate files from one main file where in one sheet data is there and in other sheet pivot. There requirement is create separate file for each group. Example there are 10 companies, create one file for one company.

    Thank you,
    Srini

  2. #2
    Board Regular ranman256's Avatar
    Join Date
    Jun 2014
    Location
    Kentucky
    Posts
    1,248
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to create separate files from main file

    not clear. Are the many sheets? 1 for each company?
    are there 2 sheets/company, 1 for data, 1 for pivot?
    how are the sheets named?

  3. #3
    New Member
    Join Date
    May 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to create separate files from main file

    Hi Raman,

    Thank you for your quick response. Here are details.

    In sheet1 Data is there from column A to U for multiple companies. In sheet 2 we have a pivot table based on company wise. So this is a consolidated file.

    Now what we want here is separate file for each company. Meaning, in sheet 1 data of first company and its pivot in sheet 2....like I need separate files for each company. The companies list may vary from 20 to 40 depends on the report we get.

    Thank you,
    Srini

  4. #4
    New Member
    Join Date
    May 2012
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Macro to create separate files from main file

      
    Hi Ranman,

    Could you please help me with the above query please.

    Thank you,
    Srini

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com