[Last Call] Learn how to a build a cloud-first strategyRegister Now


VBA Help for filtering/searching information

Posted on 2009-04-27
Medium Priority
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

Christian de Bellefeuille earned 2000 total points
ID: 24246003
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

ID: 24250622

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

834 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