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.

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>

 

[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.