+ Reply to Thread
Results 1 to 6 of 6

Copy Multiple filtered data to same column

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Cov, England
    MS-Off Ver
    Excel 2003
    Posts
    60

    Copy Multiple filtered data to same column

    Hi all

    I have a command button which filters data on worksheet "IdleTime" and copys the filtered data to to the worksheet "Idle Time M"
    The data is filtered by Month (selected by comboBox8 value) and the Time "8:00 PM"
    On "IdleTime" sheet Month is in Column 13 and time is in Column 2

    This code works fine, however i need to also Filter the "IdleTime" data with the same month (comboBox8 Value) but this time with the Time criteria "1:00 PM" Edit and criteria "Sat" (Field 14) . This filtered data needs to then be copied and pasted in the next free cell in "Idle Time M" after the data i had already pasted previously

    Currently having no luck trying to do this, please any help?

    Current Code which works for copy n paste for filtered data with just month and time 8pm
    Please Login or Register  to view this content.
    Attached workbook aswell
    Edit: please see attached in my second post
    Command button 12 is located on phone performance summary Tab> Idle time/AQ Summary Tab> Idle Time summary Frame
    Attached Files Attached Files
    Last edited by flashdisk; 06-04-2013 at 02:05 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,598

    Re: Copy Multiple filtered data to same column

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 06-03-2013 at 08:54 PM.

  3. #3
    Registered User
    Join Date
    05-01-2013
    Location
    Cov, England
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Copy Multiple filtered data to same column

    Hi Thanks for replying AlphaFrog

    Code looks great

    Apologies as i forgot to include another field in the second criteria which is why the data needs to be filtered separately and pasted below

    After it has copy n paste the filtered data for Criteria Month and Criteria 8 pm
    The second filter needs to be Criteria Month (Field 13), Criteria "1:00 PM" (Field 2), and Criteria "Sat" (Field 14)
    This is due to end of day values being entered at 8pm on weekdays and 1pm on a saturday
    Hope this makes sense?

    have attached workbook again with field 14 in IdleTime Sheet
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,598

    Re: Copy Multiple filtered data to same column

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-01-2013
    Location
    Cov, England
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Copy Multiple filtered data to same column

    Hi Thanks again for repying

    When testing the code i get a debug error on the below line?
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    05-01-2013
    Location
    Cov, England
    MS-Off Ver
    Excel 2003
    Posts
    60

    Re: Copy Multiple filtered data to same column

    Found the cause, works great. Thank you

+ 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