Resort Chart

[mattress58]

I have this long excel sheet with data. I need to find the best way to resort it. I am using formulas not and it is slowing down my page. I would like to resort it with VBA. Below is the page of data and how I need to to be resorted to

Market	Date	Brand	Days	Rate
YYZ	6/10	Delta	3	281
YYZ	6/10	American	3	294
YYZ	6/10	United	3	174
YYZ	6/10	Southwest	3	196
YYZ	6/10	Delta	7	496
YYZ	6/10	American	7	496
YYZ	6/10	United	7	810
YYZ	6/10	Southwest	7	654
YYZ	6/11	Delta	3	222
YYZ	6/11	American	3	244
YYZ	6/11	United	3	774
YYZ	6/11	Southwest	3	5596
YYZ	6/11	Delta	7	4966
YYZ	6/11	American	7	49776
YYZ	6/11	Southwest	7	64
YYZ	6/11	United	7	81550
LAX	6/10	Delta	3	261
LAX	6/10	American	3	294
LAX	6/10	United	3	174
LAX	6/10	Southwest	3	96
LAX	6/10	Delta	7	1496
LAX	6/10	American	7	496
LAX	6/10	United	7	810
LAX	6/10	Southwest	7	6654
LAX	6/11	Delta	3	22
LAX	6/11	American	3	2484
LAX	6/11	United	3	7724
LAX	6/11	Southwest	3	5596
LAX	6/11	Delta	7	4966
LAX	6/11	American	7	496
LAX	6/11	Southwest	7	64
LAX	6/11	United	7	550

What I need it to look like

Market	Brand	6/10		6/11
		3	7	3	7
YYZ	Delta	281	496	222	4966
YYZ	American	294	496	244	49776

And so on.

[adyteo]

just use a pivot table to do that for you

[mattress58]

Thanks for the quick reply. This is only part of it really. I am pulling this data into my worksheet reformatting it and then sending it out in the body of emails. I need to sort it, the color it and do some other things before it automatically goes out in an email body. All when you run it. I have all the other parts working, I am just trying to not have my file so huge and slow because I currently have 46,168 formulas sorting it.I cant have a pivit table in the body of an email.