+ Reply to Thread
Results 1 to 15 of 15

Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

  1. #1
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Hi,

    I have an excel file contains more than 40000 rows with different values. I need to filter( avoid certain rows based on the column G) and paste the remaining to another sheet . File uploaded here:-
    https drive.google.com/open?id=1MCnPOQsQd4y0r-ySRhM4sHAQSQsY7ob

    Kindly guide me

    Regards
    Spark
    Last edited by AliGW; 06-30-2019 at 01:09 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,418

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Welcome to the forum!

    Using UPPER CASE online is considered as shouting - don't shout at us, please. I have amended your thread title accordingly.

    Please attach your file directly here. Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Sorry,Thank you

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,418

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    You have not attached the file - please do so. Nobody should have to follow an external link - I have explained how to use our attachment facility.

  5. #5
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Hi, file attached
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    Hi !

    Quote Originally Posted by SPAARK View Post
    I need to filter( avoid certain rows based on the column G) and paste the remaining to another sheet
    No need any code just using an Excel basics : an advanced filter ! And use the same if a code is really necessary …

  7. #7
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Thank you , yes everyday value in amount column & other data in rows are changing ,so I think code is necessary .Please guide me

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question

    First explain us what technically that means :

    Quote Originally Posted by SPAARK View Post
    I need to filter( avoid certain rows based on the column G) and paste the remaining to another sheet .
    Which rows to avoid or which rows to copy to 'another sheet', so what are the criterion, the source sheet and the another sheet ?
    These criterion are fixed or may change ?

  9. #9
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Thank you.
    Full row related to 98582 3199842 3199843 4590271 98581 (column BG) should copied to 2 nd sheet . Rows related to 985801 31844 31998464 98746 4590271 (column BG) should not be copied .

  10. #10
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question

    Not clear on my side …

    The criteria is only the column F "BG" ? Like if F = "98582" then copy whatever the values in other columns ?
    Without an answer in my previous post so again whatever the criteria, is it fixed or it may change ?

  11. #11
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Copying should be based on values in Column F - "BG" , ie 98582 & 3199842 & 3199843 & 4590271 & 98581 .The rows ( containing 98582/ 3199842 /3199843/ 4590271 /98581 ) should be copied to next sheet ( in a single sheet). Thank you..

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Quote Originally Posted by SPAARK View Post
    I have an excel file contains more than 40000 rows with different values. I need to filter( avoid certain rows based on the column G) and paste the remaining to another sheet .
    Please Login or Register  to view this content.

  13. #13
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Question

    For the third time :

    Quote Originally Posted by Marc L View Post
    the criteria, is it fixed or it may change ?

  14. #14
    Registered User
    Join Date
    06-30-2019
    Location
    INDIA
    MS-Off Ver
    OFFICE HOME & STUDENT 2013
    Posts
    7

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    Thank you very much , it worked.I tried with column f ( below code), but getting error, please guide me

    Please Login or Register  to view this content.
    Last edited by AliGW; 07-05-2019 at 01:26 AM. Reason: New member - code tags added.

  15. #15
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Copy & Paste from an Excel Sheet to Another sheet Based on Certain Criteria

    1)
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

    2) 6 should be 7, xlFilterValues
    Please Login or Register  to view this content.

+ 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. [SOLVED] Copy and paste Rows based on 2 critera's
    By saram1989 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-04-2018, 05:29 AM
  2. Replies: 1
    Last Post: 07-18-2015, 01:28 AM
  3. [SOLVED] Copy paste data one to multiple sheet based on cell value to sheet name
    By kannan1847 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2015, 12:54 AM
  4. Code to copy and paste row from one excel sheet to another, based on criteria
    By CamSeren in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-25-2013, 04:32 AM
  5. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  6. Move data from Sheet 1 to Sheet 2 based on critera like adv filter?
    By gspivey79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 12:45 PM
  7. Replies: 3
    Last Post: 11-12-2010, 04:31 AM

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