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
Bookmarks