+ Reply to Thread
Results 1 to 9 of 9

Filter based on Range and copy paste

  1. 03-27-2015, 05:30 AM #1
    kannan1847
    kannan1847 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    65

    Filter based on Range and copy paste

    I have sample data, which contains sheet name range.in that sheet based Item, I need to Filter the Data in sheet 1 and copy paste to the specific sheet name automatically-Kindly do help me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-27-2015, 05:33 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Filter based on Range and copy paste

    Check this out.. This might help!

    www.youtube.com/watch?v=c_njIFtFZNk

    If this link does not open, check out Lesson 9 on this link..

    http://www.needforexcel.com/#!videos/c10fk
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 03-27-2015, 05:36 AM #3
    kannan1847
    kannan1847 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    65

    Re: Filter based on Range and copy paste

    Acess Denied
    Reply With QuoteRegister To Reply
  4. 03-27-2015, 06:25 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter based on Range and copy paste

    Does this help?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 03-27-2015, 07:06 AM #5
    kannan1847
    kannan1847 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    65

    Re: Filter based on Range and copy paste

    JOHN H. DAVIS






    Hi Mr. JOHN H. DAVIS

    Thanks it works
    but I need all filter criteria automatically without msg box
    Reply With QuoteRegister To Reply
  6. 03-27-2015, 07:26 AM #6
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter based on Range and copy paste

    Try:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 03-27-2015, 02:07 PM #7
    kannan1847
    kannan1847 is offline
    Registered User
    Join Date
    02-24-2014
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    65

    Re: Filter based on Range and copy paste

    super it works thaks
    Reply With QuoteRegister To Reply
  8. 03-27-2015, 02:50 PM #8
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Filter based on Range and copy paste

    You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as solved. See link for guidance.

    http://www.excelforum.com/forum-rule...rum-rules.html
    Reply With QuoteRegister To Reply
  9. 03-31-2015, 07:06 AM #9
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Re: Filter based on Range and copy paste

    Thread Tools from the menu link above and mark this thread as SOLVED.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter/Copy based sheet name paste non adjacent columns
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2014, 06:16 AM
  2. Filter Named range-then copy and paste
    By Scott Taylor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2013, 03:41 PM
  3. [SOLVED] Range Selection up to last visible adjacent cell,filter,copy paste to next sheet
    By kcube17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2013, 07:08 AM
  4. Macro to filter based on column heading then copy and paste to new sheet
    By macattackr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2012, 05:14 PM
  5. Automate Copy and Paste based on Filter?
    By NM079 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2011, 07:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1