VBA Help for filtering/searching information

Posted on 2009-04-27
Last Modified: 2013-11-25
Hi everyone,
Thanks for taking the time to read my message.
I am currently working on a spreadsheet which should filter several information.

I have three columns: one is showing a ticker (identifier of the parent company), one is showing an ISIN (Bond) and the last one is showing the currency. I would like to get the output that if one ticker has Bonds in multiple currencies all of these Bonds (ISINs) should be copied in a different sheet. This list contains about 2500 Bonds, 300 Tickers and 4 different currencies. Not every Ticker has bonds in different currencies - in fact only 50 Tickets have bonds in multiple currencies outstanding. I attached a small part of this list. The input data and range varies - that's why I need a macro.
Do you have an idea of how to solve this problem. I would appreciate every help. I am not proud of this but I worked on this for 2 days and didn't get the result I was looking for - therefore 500 pts
Question by:kbrasco
    LVL 10

    Accepted Solution

    I've coded this very simple, might not be the best code ever... but it work.

    Press CTRL-B to activate the macro.  Each ticker has its own sheet if they have multiple currencies.

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now