+ Reply to Thread
Results 1 to 5 of 5

Macro for copy all info related to one company paste to its own new tab

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    21

    Post Macro for copy all info related to one company paste to its own new tab

    All I want is to create a macro so all information related to a single company goes to its own tab.

    Like for example there is 6 entries for Company A ltd, I want macro to instruct that it creates a new tab for "A Ltd" with name of A Ltd and copy all information related to A ltd into new tab, as I had created a tab for A ltd…. I have 150 different companies for which I have to create a tab and copy paste there related information Manually..Please help


    Also Macro self creates new tab when new company added in the list

    PleClient as on May.xlsxase find attached file....

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Macro for copy all info related to one company paste to its own new tab

    Will the company tabs already exist in your file? If they do, do you want the existing data to be cleared in those tabs before copying fresh data or should the data be copied to the next available row?

    Also, do you want the data to be removed from the main tab once its copied?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    04-26-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Macro for copy all info related to one company paste to its own new tab

    Hi,
    Thank you for reply...

    No, Company tabs are not exist in my worksheet, Macro will create it.( Currently I have 100 companies).
    Data should be copied to next available row.
    No, Data should be remain in Summary (main tab).

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Macro for copy all info related to one company paste to its own new tab

    Try this code
    Please Login or Register  to view this content.
    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    To run the Excel VBA code:
    1. Press Alt-F8 to open the macro list
    2. Select a macro in the list
    3. Click the Run button

  5. #5
    Registered User
    Join Date
    04-26-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Macro for copy all info related to one company paste to its own new tab

    Hiii..

    Thank you for the reply...

    Its working...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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