+ Reply to Thread
Results 1 to 8 of 8

Advanced filter copy to dynamic range?

  1. #1
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Advanced filter copy to dynamic range?

    I'm trying to use dynamic ranges with advanced filtering. I have the original dataset from a dynamic range working correctly, however, I cannot get it to copy to a dynamic range below my dataset. Here is my attempt which does not work:

    Please Login or Register  to view this content.
    Also, if possible I would like this data to be cut rather than copied. I can work around if it's not possible to do so.

    Thanks.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Advanced filter copy to dynamic range?

    You can't cut with an advanced filter. It also looks as though you are probably trying to copy into at least part of the range you are filtering, which I don't think will work.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Re: Advanced filter copy to dynamic range?

    Quote Originally Posted by xlnitwit View Post
    You can't cut with an advanced filter. It also looks as though you are probably trying to copy into at least part of the range you are filtering, which I don't think will work.
    I agree, but how can I make the A1 dynamic?

  4. #4
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Re: Advanced filter copy to dynamic range?

    Any ideas?

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Advanced filter copy to dynamic range?

    What exactly are you trying to do? In what way does it need to be dynamic?

  6. #6
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Re: Advanced filter copy to dynamic range?

    Quote Originally Posted by xlnitwit View Post
    What exactly are you trying to do? In what way does it need to be dynamic?
    I'm trying to move certain rows that contain certain text to 2 rows below the current data set. The last row of the dataset is dynamic. Advanced filter seemed like a good option to do this but maybe there's a better way?

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Advanced filter copy to dynamic range?

    In that case perhaps
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    12-29-2012
    Location
    usa
    MS-Off Ver
    Excel 2016
    Posts
    325

    Re: Advanced filter copy to dynamic range?

    Quote Originally Posted by xlnitwit View Post
    In that case perhaps
    Please Login or Register  to view this content.
    Works perfectly.

    Thanks!

+ 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] Advanced Filter to Dynamic Range
    By John in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2019, 12:06 AM
  2. Unique Advanced Filter to new sheet using dynamic range
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2015, 06:40 PM
  3. Excel vba - copy an advanced filter range then transpose function
    By Jonno1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2015, 01:27 PM
  4. Advanced filter with dynamic critieria range
    By kilvan99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2014, 02:29 PM
  5. Dynamically hide rows for dynamic criteria range of advanced filter
    By Senator685 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-25-2013, 02:08 PM
  6. Advanced filter a dynamic date range
    By oneandoneis2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-06-2006, 03:57 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