+ Reply to Thread
Results 1 to 5 of 5

Advanced filter: multiple 'copy to' locations? extract to [location + X rows]?

  1. #1
    Registered User
    Join Date
    07-29-2010
    Location
    Western Isles, Scotland, UK
    MS-Off Ver
    Excel 2003 & sometimes 2007
    Posts
    22

    Question Advanced filter: multiple 'copy to' locations? extract to [location + X rows]?

    I'm trying to make weekly schedules from a monthly schedule of routine tasks . Some tasks get done once a week, others get done daily.

    Is it possible to use advanced filter to copy tasks listed as 'daily' on the Month worksheet to several loctions (each day) on the Week worksheet?

    I have tried but can't get it to work.

    Failing that, would it possible to select a row of headings as criteria and copy to a location several rows down from the headings? (If so, how?)

    Any and all help much appreciated!

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Advanced filter: multiple 'copy to' locations? extract to [location + X rows]?

    i think a bit more info is required "several locations" is a tad vague. for advanced filter to work and copy to a new location you'd need a crireria range have you set that up?
    you could just use ordinary filter and copy/ paste wherever you like!
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    07-29-2010
    Location
    Western Isles, Scotland, UK
    MS-Off Ver
    Excel 2003 & sometimes 2007
    Posts
    22

    Re: Advanced filter: multiple 'copy to' locations? extract to [location + X rows]?

    Thanks for the rapid response!

    That's a good point but I'm setting this schedule up for someone else with macros & trying to make it as automated as possible so that ideally they would just need to click buttons and print.

    I've set up a criteria range, yes. It works fine if just copy to one location. It doesn't work if I select one set of cells (for Monday), and then a set of cells 10 rows down (for Tuesday).

    I would want it copied to e.g. C3:H3, C13:H13, C23:H23, etc.

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Advanced filter: multiple 'copy to' locations? extract to [location + X rows]?

    you could probably do this with functions to auto populate each day

  5. #5
    Registered User
    Join Date
    07-29-2010
    Location
    Western Isles, Scotland, UK
    MS-Off Ver
    Excel 2003 & sometimes 2007
    Posts
    22

    Re: Advanced filter: multiple 'copy to' locations? extract to [location + X rows]?

    Good idea I will give it a try.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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