Pasting An Array Based On Headers

[clattenburg cake]

Hi, I'm trying to get VBA to print a column array based on a given header. The data is an xml file and there are 9 columns I am interested in copying from one sheet to a table in another sheet.

The data are odds across different sports, but I am only interested in Football odds. I have included the headers that I am interested in vArr:

Please Login or Register  to view this content.

I am not sure what to do from here. I need to print the data in the columns from each of those headers defined in vArr in a number format into a table in sheet "Footy Odds", in cells B:K.

Help please!

[Norie]

Do you mean you want to find each column listed in the array on 'Data' and then copy them to 'Footy Odds'?

Please Login or Register  to view this content.