I have a list of trades. They have their own info, etc. I want each trade to show up in its own sheet for data purposes with some kind of formula. Say I have 12 products, my entire list of trades follows the same logic, for example all trades begin with either PH- or QH-, and end with -01 to -96. I want a row to appear in a certain sheet if the criteria is met - for example, I want to move all trades that pertain to PH-01, which shows up as, for example, PH-2024-0331-01 FROM the main trades list to a sheet called PH1. Every cell from the row of that trade needs to be moved, but it's all dependent on which product this trade is for. So if I have a list of trades with several different columns, moving one of the rows to, say, sheet PH2 is only dependent on whether the trade pertains to PH2. The trade itself has several properties: ID / type / portfolio / who / etc. as you can see in the photo. Here is how the trade list looks. Once again, I want to move a trade that begins with PH- and ends with -01 to sheet PH1. Moving the other columns is dependent on whether the trade pertains to that sheet. Every column in the receiving sheet would be a formula, which I will tweak or drag. What is a way that I can do this, so I can sort the trades easier? If this is not possible the way I am explaining, please let me know.
I tried LEFT() and MID(), I tried variations of IF, but I'm not sure what the correct syntax would be. Help is greatly appreciated.