Results 1 to 2 of 2

how to set Excel Macro and filter data to new worksheets

Threaded View

TiongSH how to set Excel Macro and... 08-23-2010, 03:46 AM
venkat1926 Re: how to set Excel Macro... 08-24-2010, 08:35 AM
  1. #1
    Registered User
    Join Date
    08-23-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    1

    how to set Excel Macro and filter data to new worksheets

    Dear all

    Kindly advise how to set Excel Macro and filter data to new worksheets.
    I have worksheet DATA as attached.
    I will like to set macro so that:
    a) new worksheet contain data for ORG begins with DDD
    b) new worksheet contain data for ORG not begins with DDD
    Note: ORG in column J highlighted in yellow and letters in blue

    I have tried to do so but encoutered error and ended up with no filtered data in the newly created worksheet

    Kindly advise
    Attached Files Attached Files

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