+ Reply to Thread
Results 1 to 3 of 3

Code to filter and search for creteria and cut and paste to another tab

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    474

    Question Code to filter and search for creteria and cut and paste to another tab

    Hi,

    What I have is a workbook where I have to filter on a column called ‘Code’ in a worksheet called ‘Current’ and search for varies criteria and then copy these filerted rows and paste into a worksheet called ‘Past’ and then delete the orginal rows form the ‘Current’ tab.

    e.g. filter on a column called ‘Code’ and filter on the criteria that match ‘Monday’, ‘123’ and ‘Customer Accepted’ and paste at the bottom of the ‘Past’ tab and then delete from the ‘Current’ tab. A message should then be displayed saying “Data Transfered OK” with the curser then highliting ‘A1’ on the ‘Current’ tab

    The only cavat is that the code may find none, some or all of the required criteria, however, in the event of finding no matching data then a message should then be displayed saying “No Data Found” with the curser then highliting ‘A1’ on the ‘Current’ tab

    As I have to repeat this to filter on various columns for varoius cretia I intend to modify the code accordingly, however, in once instance I will have to filter on a column called ‘Code’ and filter on the creteria 1,2 and 3 etc but then I have to do second filter on column called ‘Code Extra’ and then do a filter on the creteria 4, 5 and 6 so the additional code would also be appreciated

    Any assistance would be gratfully appreciated

    Many thanks

    Rob
    Rob

  2. #2
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    474

    Re: Code to filter and search for creteria and cut and paste to another tab

    Hi,

    I forgot to mention I'm using Excel version 2007

    Thanks


    Rob

  3. #3
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    474

    Re: Code to filter and search for creteria and cut and paste to another tab

    Hi,


    Should I attach an example file ?


    Rob

+ 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. VB code to filter copy and paste in a different sheet
    By rshnkmr39 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2013, 12:53 AM
  2. Search mechanasim IN EXCEL with dynamic creteria
    By dipesh4uin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2012, 05:03 PM
  3. [SOLVED] Macro to search based on creteria cut and paste
    By kish_gv in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-04-2007, 06:41 AM
  4. Replies: 1
    Last Post: 05-12-2006, 07:15 PM
  5. VBA-code for search,copy and paste
    By TUNGANA KURMA RAJU in forum Excel General
    Replies: 0
    Last Post: 12-12-2005, 08:45 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