Results 1 to 10 of 10

Segregate data into different tabs based on info in column A

Threaded View

SAFC Segregate data into different... 09-28-2015, 04:35 PM
walruseggman Re: Segregate data into... 09-28-2015, 05:01 PM
FDibbins Re: Segregate data into... 09-28-2015, 05:13 PM
SAFC Re: Segregate data into... 09-29-2015, 08:08 AM
walruseggman Re: Segregate data into... 09-29-2015, 09:11 AM
SAFC Re: Segregate data into... 09-29-2015, 07:59 AM
SAFC Re: Segregate data into... 09-29-2015, 10:39 AM
JOHN H. DAVIS Re: Segregate data into... 09-29-2015, 11:59 AM
SAFC Re: Segregate data into... 09-29-2015, 02:10 PM
JOHN H. DAVIS Re: Segregate data into... 09-29-2015, 02:24 PM
  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    51

    Segregate data into different tabs based on info in column A

    Hello All,

    I am trying to create a macro that segregates all my data into different tabs based on the name in column A and then rename each tab based on what is in A2 for that tab. We have about 20 reps and this report has to be done weekly. I want it to segregate each rep into its own tab and then rename the tab based off the reps name, which would be located in $A$2 of each tab.
    Last edited by SAFC; 09-30-2015 at 09:33 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] splitting data into multiple tabs based on column criteria
    By bardobhb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-02-2014, 02:30 PM
  2. [SOLVED] How to segregate data from a column and use the count of it??
    By arun.galaxy7 in forum Excel General
    Replies: 3
    Last Post: 08-01-2014, 05:43 AM
  3. Replies: 4
    Last Post: 10-02-2013, 03:00 PM
  4. Can a macro change data on tabs when info in F7 of Job Info worksheet changes? If so How?
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-05-2012, 02:59 AM
  5. Macro to Segregate the data based on Multiple Criteria's in Multiple Columns -Challenging!
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2012, 07:31 AM
  6. Copy info from Master tab to other tabs based on conditions
    By nadiaraciti in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2011, 05:53 AM
  7. How to extract info from one column based on another's data
    By Bremus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-14-2011, 06:13 PM

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