• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

VBA Help for filtering/searching information

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
Thanks
kbrasco
macro.xls
0
kbrasco
Asked:
kbrasco
1 Solution
 
Christian de BellefeuilleProgrammerCommented:
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.
BONDS.xls
0
 
kbrascoAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now