Hi Guys,
I'm looking to copy over information from a master list of data by specifcying a specific criteria.
For example: In the info below... there's a number of Index types. I would like the code to look at the range that is all of Column C (cell by cell) and look for "AS51", if its there then to copy over the rown that it found it in to a specified tab. Loop until blank.
Essentially it's just filtering the data into a different tab by the Index.
Help please.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
I'm looking to copy over information from a master list of data by specifcying a specific criteria.
For example: In the info below... there's a number of Index types. I would like the code to look at the range that is all of Column C (cell by cell) and look for "AS51", if its there then to copy over the rown that it found it in to a specified tab. Loop until blank.
Essentially it's just filtering the data into a different tab by the Index.
Help please.
Swap Code | Counterparty | Index | Spread (bps) | Date | Return Against | Reference Rate | % Spread |
2046 | BNP | AS51 | -80 | 1/31/2007 | CDOR03 Index | 4.35143 | -0.8 |
2046 | DEB | AS51 | -20 | 1/31/2007 | CDOR03 Index | 4.35143 | -0.2 |
2046 | GSI | AS51 | 0 | 1/31/2007 | CDOR03 Index | 4.35143 | 0 |
2149 | BNP | AS51 | -45 | 8/17/2007 | CDOR03 Index | 4.91143 | -0.45 |
2149 | CBC | AS51 | -20 | 8/17/2007 | CDOR03 Index | 4.91143 | -0.2 |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>