Results 1 to 5 of 5

Excel Macro filtering only 1st item out of multiple items from the source data

Threaded View

  1. 09-29-2015, 01:01 PM #1
    zipperzipped1204
    zipperzipped1204 is offline
    Registered User
    Join Date
    09-27-2015
    Location
    India
    MS-Off Ver
    MS Office 2013
    Posts
    2

    Excel Macro filtering only 1st item out of multiple items from the source data

    Hi,

    Can someone please help me with a problem i am facing in excel wherein when i filter my data using the macro, only the first item is being filtered. i have attached the sheet, can someone please advise what coding in the macro is wrong. i have the button in sheet 1, when i press it, it asks for the fund number. i enter a fund number and only the first item from the source data is selected. my data is in sheet 2 and i obtain the result in sheet 3. Please use fund 2618 as example as it has multiple line items in the source data
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED]How to VLookup multiple items when the source has multiple identical numbers
    By jackson_hollon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2014, 12:56 AM
  2. Macro with nested loop to combine each item of a colum with multiple items of another col
    By Creare in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-24-2013, 05:52 AM
  3. [SOLVED] Custom filtering problem for multiple item
    By ryan4646 in forum Excel General
    Replies: 1
    Last Post: 08-28-2013, 03:22 AM
  4. Macro for selecting a single item while filtering the data in Pivot Table
    By Syed964 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 01:28 PM
  5. Auto Filtering Macro that Filters for more than one item
    By murph8868 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2013, 03:18 PM
  6. Multiple filtering criteria and keeping filtered OUT items in total - Excel 2010
    By lawsoga in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-25-2012, 11:34 AM
  7. Excel Data Validation - Select Multiple Items - Need to Apply Macro to Multiple Rows
    By kristynroll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2012, 07:44 PM

Tags for this Thread

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