Copy data from one sheet to another using a specific criterion

[nadaraza]

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.

[TABLE="width: 789"]
<TBODY>[TR]
[TD]Swap Code[/TD]
[TD]Counterparty[/TD]
[TD]Index[/TD]
[TD]Spread (bps)[/TD]
[TD]Date[/TD]
[TD]Return Against[/TD]
[TD]Reference Rate[/TD]
[TD]% Spread[/TD]
[/TR]
[TR]
[TD="align: right"]2046[/TD]
[TD]BNP[/TD]
[TD]AS51[/TD]
[TD]-80[/TD]
[TD]1/31/2007[/TD]
[TD]CDOR03 Index[/TD]
[TD="align: right"]4.35143[/TD]
[TD="align: right"]-0.8[/TD]
[/TR]
[TR]
[TD="align: right"]2046[/TD]
[TD]DEB[/TD]
[TD]AS51[/TD]
[TD]-20[/TD]
[TD]1/31/2007[/TD]
[TD]CDOR03 Index[/TD]
[TD="align: right"]4.35143[/TD]
[TD="align: right"]-0.2[/TD]
[/TR]
[TR]
[TD="align: right"]2046[/TD]
[TD]GSI[/TD]
[TD]AS51[/TD]
[TD]0[/TD]
[TD]1/31/2007[/TD]
[TD]CDOR03 Index[/TD]
[TD="align: right"]4.35143[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]2149[/TD]
[TD]BNP[/TD]
[TD]AS51[/TD]
[TD]-45[/TD]
[TD]8/17/2007[/TD]
[TD]CDOR03 Index[/TD]
[TD="align: right"]4.91143[/TD]
[TD="align: right"]-0.45[/TD]
[/TR]
[TR]
[TD="align: right"]2149[/TD]
[TD]CBC[/TD]
[TD]AS51[/TD]
[TD]-20[/TD]
[TD]8/17/2007[/TD]
[TD]CDOR03 Index[/TD]
[TD="align: right"]4.91143[/TD]
[TD="align: right"]-0.2[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[nadaraza]

Hey Aladin,

In you formula's... for B4 you say to input: =IF($A4="","",INDEX('Raw Data'!$B$2:$G$27,$A4,MATCH(B$3,'Raw Data'!$B$1:$G$1,0)))

its referencing a cell in B3 which is blank..... is there a value that's supposed to be in there?

 

[nadaraza]

Hey Aladin,

In you formula's... for B4 you say to input: =IF($A4="","",INDEX('Raw Data'!$B$2:$G$27,$A4,MATCH(B$3,'Raw Data'!$B$1:$G$1,0)))

its referencing a cell in B3 which is blank..... is there a value that's supposed to be in there?

Oops nevermind i got it, deleted the column headings by accident. Thx

 

[Aladin Akyurek]

Hey Aladin,

In you formula's... for B4 you say to input: =IF($A4="","",INDEX('Raw Data'!$B$2:$G$27,$A4,MATCH(B$3,'Raw Data'!$B$1:$G$1,0)))

its referencing a cell in B3 which is blank..... is there a value that's supposed to be in there?

Oops nevermind i got it, deleted the column headings by accident. Thx

Great. Glad to hear that you sorted it out.