Hi,

I would like a VBA code to:
1) Create a New sheet called "Ranking"
2) In this new sheet, I want to create a list.
In A1 I want to have "Ranking", B1 I want to have "Category, C1 I want to have "ID", D1 I want to have "Name"
From A2 till A1010 a list of numbers: A2 I want to have 1, A3 I want to have 2, A4 I want to have 3, etc.
From B2 till B38 I want the following list: DOM1, PKG, DOM1, INT, EU, DOM1, PKG, DOM1, INT, EU, DOM1, PKG, DOM1, INT, EU, DOM2, PKG, DOM2, INT, EU, DOM2, PKG, DOM2, INT, EU, DOM2, PKG, DOM2, INT, EU, DOM1, PKG, DOM1, INT, EU

Any help?