Filtering Data based on row data and extract - VBA Code

[lejoyeux3]

Hello All,


I have some data set up as per below:


Header has three rows then multiple columns:

		ABC	KOP	KLP	TGF	KLO	NOM	DAN
		1425	8745	4256	2536	458	985	74856
		Apple	Mango	Apple	Orange	Orange	Mango	Apple
Piority		1	4	9	6	8	4	3
Issue		20	5	7	7	1	0	9
Meeting		15	24	26	52	12	23	14
Resolution		1	2	4	3	1	4	1

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>

Now, what I want to do is, by using excel VBA, be able to this based on the thrid row data.


It means, I want to be able to via VBA code group and extract data only based on value "Apple", so that in the extract I only have data for apple in a separate sheet with sheet name "Apple + Date it was extracted"


Can any one assist me with that?




Thanks in advance

 

[lejoyeux3]

Hello Guys,

Any suggestion?

Many tks