Forum Discussion
Keeping Rows that Match Another Worksheet
One of the delightful aspects of Excel is that there are always multiple ways to accomplish a given objective. In your case, I have some questions and suggestions. It would help--let me say this in advance--if you were to post a copy of your actual workbook or (if it contains proprietary info) a replica with false names and identifiers that would still enable us to see what you're working with.
If I were in your place, I think I'd want to keep in a basic raw database clients who had been clients in the past but are for the moment not in your blotter. Having a historical record can come in handy, along with a clear way to know who is current. Toward that end, what you might want to have is made of multiple parts:
- a database on one worksheet that contains all past and current clients
- a sheet that shows only current
- your "TradeBlotter" workbook
- other related items
To create item #2 above, from #1 and #3 you could use Power Query (which I don't have on my Mac) or, if you have the most current version of Excel, you might well be able to make use of FILTER. Here's a video that explains the FILTER function. https://www.youtube.com/watch?v=9I9DtFOVPIg
Your secondary question regarding the creation of a series of identifiers--A2, A3, A4, etc--is readily resolved (part of the problem of course is that it's not just simple math here because what you've created is text rather than numbers), but secondary to the primary issue. Let's deal with it later.