+ Reply to Thread
Results 1 to 11 of 11

Copy filtered list to another sheet

  1. 03-02-2015, 09:56 AM #1
    bdrilling33
    bdrilling33 is offline
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Copy filtered list to another sheet

    Hello all,

    I am needing to copy a filtered list to a another sheet (8 actually) each sheet has different criteria (location) Attached are results for what I am looking for.

    thanks
    BD

    Filter - Copy example.xlsx
    Reply With QuoteRegister To Reply
  2. 03-02-2015, 10:50 AM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Copy filtered list to another sheet

    Do you need only the list of Customer per District value?
    If yes have seen the use of the Pivot Table ?
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 03-02-2015, 10:53 AM #3
    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: Copy filtered list to another sheet

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 03-02-2015, 11:28 AM #4
    bdrilling33
    bdrilling33 is offline
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: Copy filtered list to another sheet

    Quote Originally Posted by JOHN H. DAVIS View Post
    Maybe:

    Please Login or Register  to view this content.
    I get an out of range on this line?
    Reply With QuoteRegister To Reply
  5. 03-02-2015, 11:34 AM #5
    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: Copy filtered list to another sheet

    Do all your values in Column A have a Sheet by that name?
    Reply With QuoteRegister To Reply
  6. 03-02-2015, 12:00 PM #6
    bdrilling33
    bdrilling33 is offline
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: Copy filtered list to another sheet

    Yes, I will have 10 district sheets total
    Reply With QuoteRegister To Reply
  7. 03-02-2015, 12:04 PM #7
    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: Copy filtered list to another sheet

    Could there be xtra spaces in thouse district sheet names?
    Reply With QuoteRegister To Reply
  8. 03-02-2015, 12:39 PM #8
    bdrilling33
    bdrilling33 is offline
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: Copy filtered list to another sheet

    No, they are all macro created
    Reply With QuoteRegister To Reply
  9. 03-03-2015, 12:14 PM #9
    bdrilling33
    bdrilling33 is offline
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: Copy filtered list to another sheet

    were we ever able to come up with something on this?
    Reply With QuoteRegister To Reply
  10. 03-03-2015, 12:43 PM #10
    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: Copy filtered list to another sheet

    Try:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 03-03-2015, 12:59 PM #11
    bdrilling33
    bdrilling33 is offline
    Forum Contributor
    Join Date
    05-30-2014
    Posts
    112

    Re: Copy filtered list to another sheet

    it gets held up at the same spot. If you can get it to work for one sheet specificly (Alice) I can adjust it to work with the others if I need to.
    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. Marco to copy some filtered date on one sheet to another sheet in the same shared workbook
    By Greaser2k in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-10-2013, 08:17 AM
  2. [SOLVED] How do I create an automatic list in an excel sheet with filtered data from another sheet?
    By tiffiniexx in forum Excel General
    Replies: 4
    Last Post: 12-27-2012, 05:31 AM
  3. Filter, copy filtered data into another sheet, create a file of that sheet..
    By titushanke in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-17-2012, 02:26 PM
  4. Copy & Paste from a filtered list
    By Penelope in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2009, 04:36 AM
  5. Copy filtered list to new sheet?
    By drdavidge in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2007, 01:34 PM

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