+ Reply to Thread
Results 1 to 9 of 9

Advanced filter from Main sheet & paste in multiple sheets having different criteria

  1. 05-01-2014, 02:14 AM #1
    lalaarif1
    lalaarif1 is offline
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    270

    Advanced filter from Main sheet & paste in multiple sheets having different criteria

    1 quick question.

    In the excel workbook I have a main data sheet.

    There are multiple sheets with different criteria ( for advanced filter from the main data sheet.)

    Is there any macro which can produce the result in multiple sheets from the main data sheet?

    Please assist.

    Mail me on------------ also.
    Last edited by Fotis1991; 05-01-2014 at 02:20 AM. Reason: Not the best idea to post your mail here...
    Reply With QuoteRegister To Reply
  2. 05-01-2014, 02:56 AM #2
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    It would be best to set up a small sample file that simulates the scenario. Show us a simulated main sheet and inform of what criteria must be used and how to determine which sheet the filtered data must be sent to. A before and after view within your sample workbook will be a good starting point. Please desensitize any necessary data.
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
  3. 05-02-2014, 06:27 AM #3
    lalaarif1
    lalaarif1 is offline
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    270

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    Thanks.

    I am attaching my working.

    My criteria would be "BU" (e.g Retail, Corporate, AIB.

    I need a macro which will filter the "BU" in Data worksheet and paste the solution in respective BU worksheets.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 05-02-2014, 07:45 AM #4
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    Hi,

    Here is your sample workbook with a macro to split the data into their own sheets...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-02-2014, 07:53 AM #5
    lalaarif1
    lalaarif1 is offline
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    270

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    Thanks a million.

    You made my day. Its excellent.
    Reply With QuoteRegister To Reply
  6. 05-02-2014, 07:58 AM #6
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    Happy to help...
    Reply With QuoteRegister To Reply
  7. 05-02-2014, 08:00 AM #7
    lalaarif1
    lalaarif1 is offline
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    270

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    1 quick question.

    Can you please add freeze pane command from b2 and auto-filter command in row 1 ?

    it would be much appreciated.
    Reply With QuoteRegister To Reply
  8. 05-02-2014, 08:14 AM #8
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    Hi,

    Replace the current macro with this new one...

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 05-02-2014, 08:35 AM #9
    lalaarif1
    lalaarif1 is offline
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    270

    Re: Advanced filter from Main sheet & paste in multiple sheets having different criteria

    Once again.... thanks a trillion...

    Enjoy.
    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. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  2. [SOLVED] Search multiple sheets for criteria and paste all matched rows in new sheet
    By BertLady56 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2012, 01:09 PM
  3. Advanced filter using multiple criteria
    By logan131131 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2012, 11:36 AM
  4. Advanced Filter with multiple criteria
    By inspiresit in forum Excel General
    Replies: 6
    Last Post: 08-12-2010, 11:21 AM
  5. Advanced filter on multiple criteria
    By agalloch in forum Excel General
    Replies: 2
    Last Post: 08-19-2009, 09:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1