populating a full list of all like (tyres)

[papare]

I am trying to create a spreadsheet the will populate/pull all tyre sizes that I have collected from different suppliers.

[TABLE="width: 389"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Tyre Size[/TD]
[TD]165/80 R13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Size[/TD]
[TD]Brand[/TD]
[TD]Cost Price[/TD]
[TD]Selling Price[/TD]
[TD]Supplier [/TD]
[/TR]
</tbody>[/TABLE]


Cannt use Vlookup as it will list only one option.

Kindly Assist
Papare

 

[Momentman]

We might need more info? Where is the data being looked up from (sheet and columns), where would it be populated.

'cos it looks like a macro would be more suited for ur request

 

[papare]

The data being looked from a sheet (data)... It will populate on a Sheet @Summary@ from cell B8..

 

[Momentman]

Whats the structure of the data sheet, sample data if you can

 

[papare]

hi,

please see sample data below. the summary page should list all tyre sizes that is typed in cell (C2 e.g. 185/70 R).
[TABLE="width: 385"]
<colgroup><col span="4"><col></colgroup><tbody>[TR]
[TD]Size[/TD]
[TD]Brand[/TD]
[TD]Pattern[/TD]
[TD]Prices[/TD]
[TD]Supplier Name[/TD]
[/TR]
[TR]
[TD]185/70 R14[/TD]
[TD="colspan: 2"]LingLong LL700[/TD]
[TD="align: right"]4,000.00[/TD]
[TD]Ayan Auto Tyres[/TD]
[/TR]
[TR]
[TD]185/70 R14[/TD]
[TD="colspan: 2"]LingLong LMA3[/TD]
[TD="align: right"]4,000.00[/TD]
[TD]Ayan Auto Tyres[/TD]
[/TR]
[TR]
[TD]195R14[/TD]
[TD="colspan: 2"]LingLong LMC5[/TD]
[TD="align: right"]5,000.00[/TD]
[TD]Ayan Auto Tyres[/TD]
[/TR]
[TR]
[TD]185/70 R14[/TD]
[TD="colspan: 2"]LingLong LL700[/TD]
[TD="align: right"]4,500.00[/TD]
[TD]East Tyres[/TD]
[/TR]
[TR]
[TD]185/70 R14[/TD]
[TD="colspan: 2"]LingLong LMA3[/TD]
[TD="align: right"]3,500.00[/TD]
[TD]East Tyres[/TD]
[/TR]
[TR]
[TD]195R14[/TD]
[TD="colspan: 2"]LingLong LMC5[/TD]
[TD="align: right"]3,200.00[/TD]
[TD]East Tyres[/TD]
[/TR]
[TR]
[TD]185/70 R14[/TD]
[TD="colspan: 2"]LingLong LL700[/TD]
[TD="align: right"]4,500.00[/TD]
[TD]Conti Tyres[/TD]
[/TR]
[TR]
[TD]185/70 R14[/TD]
[TD="colspan: 2"]LingLong LMA3[/TD]
[TD="align: right"]3,500.00[/TD]
[TD]Conti Tyres[/TD]
[/TR]
[TR]
[TD]195R14[/TD]
[TD="colspan: 2"]LingLong LMC5[/TD]
[TD="align: right"]3,200.00[/TD]
[TD]Conti Tyres

[/TD]
[/TR]
</tbody>[/TABLE]