I have a list of about 5000 investors and need to create a new sheet with the names, contact info and description of the investors who have the keyword 'debt' in their description. How would I go about doing this?
| +186 | Evercore > Goldman and I don’t think it’s particularly close anymore | 65 | 10h |
| +157 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 1d |
| +92 | Santander IB? | 10 | 4d |
| +87 | UBS Offer Day | 30 | 1d |
| +71 | I hate Wells Fargo | 19 | 1d |
| +71 | Think Twice before Recruiting for HOUSTON IB!! | 38 | 43m |
| +52 | No return offer - feeling like a failure is an understatement | 21 | 50m |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 1d |
| +47 | WF Return offers | 28 | 3d |
| +40 | 2026 Investment Banking Return Offer Climate | 25 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
You just need a filter in the description column to do this. Simply "filter" the data, using a "text filter" --> "contains" and type in debt as the key word.
It should quickly provide you with all rows that have "debt" anywhere in the column you choose to filter.
Problem solved?
My apologies, I should have been more specific...
These are the columns in the list I have: Column A (Firm Name) Column B (Location) Column C (Contacts) Column E (Phone) Column G (Email) Column J (Strategies)
I need to cut this list down based on two pieces of criteria 1) Column J must contain 'debt' and 2) Column B must contain specific (city name, country)...
My MD made it clear that he wanted a macro.
I myself don't know how to write VBA, but it isn't difficult to accomplish whatever task you need by google searching "VBA" and whatever task you need "filter data/delete if."
There's plenty of sites with people solving these problems and leaving the code.
send it over and i'll have a look
You can use a wildcard as a filter for that column of cells using debt
Then do the same for the 'Location' column?
I don't even understand what you're asking anymore. You first asked about the word debt and now you're introducing another constraint about location. What is your constraint on location?
use a =isnumber(search("debt",Cell)) and loop it through in VBA. Have VBA copy the filtered list to a new workbook.
Kinda ridiculous the MD wants it done in VBA though.
I tried to create this thing for you, but I decided I wasn't willing to push myself any closer to the brink of suicide. Fuck VBA. This is such an easy thing to do it shouldn't even be an issue.
Please send me a link with proper instructions. I still can't get this damn thing to work.
This sounds like a perfect task for the intern to do by hand.
Just use a wildcard vlookup function =if(iserror(vlookup(""&"debt"&"",array,1,false)),"","debt found") in VBA for the range you define.
if you know what you need to do manually, I think you should just be able to 'record macro' as you complete the steps. That should give you the macro
It will, but I imagine the point of the macro is to recreate this for similar reports. In which case, after you record, you need to edit the code any place you see VBA call out specific cells (such as vlookup down to B152). You would need to use something like this:
Dim LR As Long LR = ActiveSheet.UsedRange.Rows.Count Range("B2").AutoFill Destination:=Range("B2:B" & LR) End Sub
This will allow the code to work for any size spreadsheet, instead of whatever number of rows you record. If your MD doesn't need this work repeated, then he is a moron for asking for VBA
Veritatis voluptatem ratione dolores. Consequatur sed aut optio incidunt sequi ut deserunt. Veritatis et qui officia architecto rerum. Aut magnam modi iusto id eligendi.
Architecto quam architecto sint consequatur provident ipsa sed. Corporis et accusamus sed eos. Perspiciatis dolorem odio officiis molestias animi explicabo voluptas. Consequatur dolore excepturi deserunt sed. A vel id ea. Similique veniam ut dolorem distinctio. Aliquam assumenda voluptates repellat sed sed.
Quae natus iste placeat consequatur. Est nemo quia soluta possimus consequatur ut. Suscipit quaerat consequatur est dolores velit. Enim aspernatur deserunt facilis reiciendis cumque. Est molestias odit consequatur. Eligendi rerum libero voluptatem quasi inventore. Aut rerum consectetur et fugit ut cum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...