Copying data from one cell dependant on value in another

Hi,

I have a table that has various columns in and I want to be able to copy data in one column, depending on the value of another colum into the a different sheet. I have attached a sample spreadsheet of what I want to do.

So for example in the table on the tab data, I want to be able to copy all of the codes in column H that that correspond to the code AUS in column G into another sheet called Code in cell B3, which I have named AUS.

There are few countries that I need to do this for, so for anyhting in column G that is GRE, I want to copy the values in column H for all GRE to the code tab and cell D3 whcih I have named GRE.

Any help would be much appreciated.

Thanks,
Dominic.

Add a helper column in Data sheet:

So in J1, enter:

Please Login or Register  to view this content.

and copy down

Then in B1 of Code sheet enter:

Please Login or Register  to view this content.

to count number of matches.

Copy B1 and paste to D1, F1, H1

It is assumed that the codes in column G can be derived from the left 3 characters of the countries in row 2 of the Code sheet

Then in B3 enter:

Please Login or Register  to view this content.

and copy down as far as you wish.

Copy this column of column of formulas to D3, F3, and H3.

Note: It would be easier if you did not have blank columns between... then you would need to enter formula once and copy across the columns and down the rows.