Copy data from one sheet to another using a specific criterion

N

nadaraza

New Member
Joined
Jul 6, 2012
Messages
20
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]
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Hi, could you attach one sample file, if possible. As far as I understand you have a table from which you want to follow column C, which can contain symbols AS51 and then transferred them to another Sheet or wrong?
Regards
 
Upvote 0
Sure thing. I do have a sample file but file attachments cannot be posted on here....I can email it you?

Yep that's exactly it i have liek 1000s of line of data which contain different symbols...once i get an idea how to do it for the AS51 symbol i can just use the same code for the others i'd sort into other sheets.
 
Upvote 0
Hi friend download this file and I think that's what you need. There is little shift, but it works exactly as you want. Tried and workable.
I wish you luck -> DOX.bg -
 
Upvote 0
nadaraza said:
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. :)

...
Click to expand...

nadaraza said:
Awesome. Thanks.

link to example is: example.xls downloaden
Click to expand...

Raw Data, A1:G27...
[TABLE="width: 475"]
<colgroup><col style="width: 56pt; mso-width-source: userset; mso-width-alt: 2673;" width="75"> <col style="width: 48pt;" width="64"> <col style="width: 49pt; mso-width-source: userset; mso-width-alt: 2332;" width="66"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3811;" width="107"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2929;" width="82"> <col style="width: 86pt; mso-width-source: userset; mso-width-alt: 4067;" width="114"> <col style="width: 94pt; mso-width-source: userset; mso-width-alt: 4465;" width="126"> <tbody>[TR]
[TD="class: xl64, width: 75, bgcolor: transparent"]Swap Code[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Cpty[/TD]
[TD="class: xl64, width: 66, bgcolor: transparent"]Index[/TD]
[TD="class: xl64, width: 107, bgcolor: transparent"]Spread (bps)[/TD]
[TD="class: xl64, width: 82, bgcolor: transparent"]Date[/TD]
[TD="class: xl64, width: 114, bgcolor: transparent"]Return Against[/TD]
[TD="class: xl64, width: 126, bgcolor: transparent"]Reference Rate[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-45[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1/31/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.35143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl63, bgcolor: transparent"]DEB[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-20[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1/31/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.35143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl63, bgcolor: transparent"]GSI[/TD]
[TD="class: xl63, bgcolor: transparent"]MIB40[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-23[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1/31/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.35143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]MIB40[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-45[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]8/17/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.91143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-20[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]8/17/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.91143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-23[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]9/21/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.86286[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl63, bgcolor: transparent"]DEB[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-35[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]9/21/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.86286[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]MIB40[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]10/19/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.82714[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl63, bgcolor: transparent"]DEB[/TD]
[TD="class: xl63, bgcolor: transparent"]MIB40[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-9[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]10/19/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.82714[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl63, bgcolor: transparent"]JPM[/TD]
[TD="class: xl63, bgcolor: transparent"]MIB40[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]10/19/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.82714[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]11[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-30[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]11/16/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.75857[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]12[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]11/16/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.75857[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl63, bgcolor: transparent"]CRS[/TD]
[TD="class: xl63, bgcolor: transparent"]AS51[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-36[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]11/16/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.75857[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]14[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]MIB40[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-51[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]11/19/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.76143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]15[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-25[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]11/19/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.76143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]16[/TD]
[TD="class: xl63, bgcolor: transparent"]CRS[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-23[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]11/19/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.76143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]17[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-35[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]12/21/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.81714[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]18[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]SPX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-25[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]12/21/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.81714[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]19[/TD]
[TD="class: xl63, bgcolor: transparent"]DEB[/TD]
[TD="class: xl63, bgcolor: transparent"]SPX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-13[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]12/21/2007[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.81714[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]20[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-37[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1/18/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.21143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]21[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-30[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1/18/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.21143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]22[/TD]
[TD="class: xl63, bgcolor: transparent"]CRS[/TD]
[TD="class: xl63, bgcolor: transparent"]SPX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]1/18/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4.21143[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]23[/TD]
[TD="class: xl63, bgcolor: transparent"]BNP[/TD]
[TD="class: xl63, bgcolor: transparent"]SPX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-36[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2/15/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3.94571[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]24[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]SPX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-51[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2/15/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3.94571[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]25[/TD]
[TD="class: xl63, bgcolor: transparent"]DEB[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-25[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]2/15/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3.94571[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent, align: right"]26[/TD]
[TD="class: xl63, bgcolor: transparent"]CBC[/TD]
[TD="class: xl63, bgcolor: transparent"]AEX[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]-35[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]3/20/2008[/TD]
[TD="class: xl63, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3.6[/TD]
[/TR]
</tbody>[/TABLE]

AS51, with the processing in A:G...
[TABLE="width: 467"]
<colgroup><col style="width: 70pt; mso-width-source: userset; mso-width-alt: 3299;" width="93"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2133;" width="60"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1792;" width="50"> <col style="width: 81pt; mso-width-source: userset; mso-width-alt: 3840;" width="108"> <col style="width: 64pt; mso-width-source: userset; mso-width-alt: 3015;" width="85"> <col style="width: 84pt; mso-width-source: userset; mso-width-alt: 3982;" width="112"> <col style="width: 85pt; mso-width-source: userset; mso-width-alt: 4010;" width="113"> <tbody>[TR]
[TD="class: xl65, width: 93, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, width: 60, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 50, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 108, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 85, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 112, bgcolor: transparent"] [/TD]
[TD="class: xl66, width: 113, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Swap Code[/TD]
[TD="class: xl67, bgcolor: transparent"]Cpty[/TD]
[TD="class: xl67, bgcolor: transparent"]Index[/TD]
[TD="class: xl67, bgcolor: transparent"]Spread (bps)[/TD]
[TD="class: xl67, bgcolor: transparent"]Date[/TD]
[TD="class: xl67, bgcolor: transparent"]Return Against[/TD]
[TD="class: xl67, bgcolor: transparent"]Reference Rate[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl66, bgcolor: transparent"]BNP[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-45[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]1/31/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.35143[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl66, bgcolor: transparent"]DEB[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-20[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]1/31/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.35143[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl66, bgcolor: transparent"]CBC[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-20[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]8/17/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.91143[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent"]BNP[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-23[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]9/21/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.86286[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent"]DEB[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-35[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]9/21/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.86286[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]11[/TD]
[TD="class: xl66, bgcolor: transparent"]BNP[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-30[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]11/16/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.75857[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]12[/TD]
[TD="class: xl66, bgcolor: transparent"]CBC[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]0[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]11/16/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.75857[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl66, bgcolor: transparent"]CRS[/TD]
[TD="class: xl66, bgcolor: transparent"]AS51[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]-36[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]11/16/2007[/TD]
[TD="class: xl66, bgcolor: transparent"]CDOR03 Index[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4.75857[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

A1: AS51

A2, just enter:
Rich (BB code): 
=COUNTIF('Raw Data'!$C$2:$C$27,A1)
A4, control+shift+enter, not just enter, and copy down:
Rich (BB code): 
=IF(ROWS($A$4:A4)<=$A$2,SMALL(IF('Raw Data'!$C$2:$C$27=$A$1,
  ROW('Raw Data'!$C$2:$C$27)-ROW('Raw Data'!$C$2)+1),ROWS($A$4:A4)),"")
B4, just enter, copy across, and down:
Rich (BB code): 
=IF($A4="","",INDEX('Raw Data'!$B$2:$G$27,$A4,MATCH(B$3,'Raw Data'!$B$1:$G$1,0)))

Repeat the process for other index values on the relevant sheets.
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
Copy data from one sheet to another sheet quickly.
Replies
5
Views
508
johnnyL
J
T
  • Solved
Trouble using VBA to copy multiple rows from one sheet to another
Replies
7
Views
1K
kevin9999
K
H
  • Question Question
Copy rows from one sheet to another sheet whose name is given by the user.
Replies
4
Views
481
harzer
H
J
  • Question Question
Copying data row by row from one sheet to another
Replies
7
Views
425
Z51
Z
T
  • Solved
Copy data from one sheet to another using headers and placements.
Replies
5
Views
493
mumps
mumps

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top