Page 1 of 4 1 2 3 ... LastLast
Results 1 to 10 of 31

Thread: Copy of rows from one sheet to another sheets based on certain criteria

  1. #1

    Copy of rows from one sheet to another sheets based on certain criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Sir,

    I have spreadsheet with column ID. I want to copy data from Raw data sheet to other six sheet on the following criteria:

    1.If ID is single then these records may copied to 1 Referral
    2.If ID column contains double IDs then these rows may be copied to 2 Referral sheet
    3.IF ID.....................3 same values ............................................3 Referral sheet
    4.............................................................................................4 Referral Sheet
    5.............................................................................................5 Referral Sheet
    6. If ID column contains 6 or more than six same values then............6 Referral Sheet

    My worksheet is attached:

    https://www.dropbox.com/s/qfh1v4sial...king.xlsx?dl=0

    Kindly solve my problem and return the same after solution.

    Regards

    Shehbaz H.

  2. #2
    Excel 2010 with free Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    No formulas, no VBA code.
    http://www.mediafire.com/view/5au9fj...07_04_15a.xlsx

  3. #3
    Acolyte Jean Paul's Avatar
    Join Date
    May 2015
    Posts
    22
    Articles
    0
    Excel Version
    2013
    Can this help you
    Attached Files Attached Files

  4. #4
    Quote Originally Posted by Jean Paul View Post
    Can this help you
    When i run the macro all data has been cleared. No data in any sheet is available. Moreover, I need only copy instead of moving of data.

  5. #5
    Sir, Please tell me the procedure for creating this file.
    Quote Originally Posted by Herbds7 View Post
    Excel 2010 with free Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    No formulas, no VBA code.
    http://www.mediafire.com/view/5au9fj...07_04_15a.xlsx

  6. #6
    Acolyte Jean Paul's Avatar
    Join Date
    May 2015
    Posts
    22
    Articles
    0
    Excel Version
    2013
    You don't run the macro, he do that when you open the tab sheet "referral" for you, ad data in you raw data sheet and look in a referral sheet.

  7. #7
    I approve of Jean Paul's solution.
    Mine is for advanced users.
    Power Query books are available.

  8. #8
    I really appreciate Jean Paul's solution. This is what i want. You are great sir.
    [tQUOTE=Herbds7;19221]I approve of Jean Paul's solution.
    Mine is for advanced users.
    Power Query books are available.[/QUOTE]

  9. #9
    Dear Sir,

    Hi

    I would like to have the same work with different column "Referred By", If column K is an exact match, it will pull the row into the referral sheets. The number of matches will determine what sheet it goes into. I want to see how many times the referred by person has referred patients. Can you do it sir?

    Kind Regards
    Shehbaz

  10. #10
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    766
    Articles
    0
    Excel Version
    Excel 2010 64bit
    You must think these forums are to be used as a contest.

    Why don't you read this http://www.excelguru.ca/content.php?184

Page 1 of 4 1 2 3 ... LastLast

Posting Permissions

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