+ Reply to Thread
Results 1 to 4 of 4

Sort data to new sheet based on criteria

  1. #1
    Registered User
    Join Date
    08-20-2019
    Location
    India
    MS-Off Ver
    office 2013 student
    Posts
    9

    Sort data to new sheet based on criteria

    hi,
    i have an excel file.it contains data in various columns and rows ie MSV, OEM, AGE, SITE and COUNT .File has to sort and copy to next sheet based on age wise, site wise , oem wise & msv wise .A sample file attached . Every day the input data will change and accordingly the out put sheet has to update automatically . I am novice in Macros .Kindly guide me .Thanks in advance

    Spaark
    Attached Files Attached Files
    Last edited by FDibbins; 08-20-2019 at 11:28 PM. Reason: Title changed.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Sort data to new sheet based on criteria

    Hi, welcome to the forum

    I have amended your thread title for you (this time). Please make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-20-2019
    Location
    India
    MS-Off Ver
    office 2013 student
    Posts
    9

    Re: Sort data to new sheet based on criteria

    hi, Noted Thank you

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,557

    Re: Sort data to new sheet based on criteria

    Does the MS-Off Ver: office 2013 student mean that you are a student or that you are using the home and student edition?
    If you are a student is this a school assignment?
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Excel 2007, excel macros not working from previous book under excel 2010
    By benich in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-30-2016, 11:48 AM
  2. Can you convert excel macros to word macros (for formatting)?
    By tahi.laci in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2015, 10:33 AM
  3. Replies: 0
    Last Post: 06-09-2015, 09:30 PM
  4. Excel Document with Macros or Access file with Macros
    By jcchs2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2015, 01:21 PM
  5. Excel Crashes when i enable macros...even with no macros.
    By comp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2014, 06:07 PM
  6. is excel macros different from sun open office macros?
    By hotmalepiyush in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2008, 01:18 AM
  7. [SOLVED] Training: More on how to use macros in Excel: Recording Macros
    By ToriT in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2006, 03:10 PM

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