a macro for soccer data

[khanaran]

HI I downloaded data from football data dot co uk and have macros that were created for me to sort the data out.

I need a macro that would be able to copy team information from the data into respective worksheets for each team


I can attach my data for your perusal and help


Regards

Raj

[Ken Puls]

Hi Raj,

Doesn't appear to be an attachment. Double click the Reply to Thread button and use "Manage" to upload your workbook.

[khanaran]

hi

having a problem with managing attachments

the size of my workbook is 11.0mb


so cannot seem to upload the file

any help will be appreciated

[Ken Puls]

Do you have a skydrive account? If not, sign up for a hotmail address. You can then upload it there, and share a link publicly. Post that here, and we should be good to go. If you can't post the link, then email it to me at ken at excelguru dot ca.

[Bob Phillips]

You could filter the data by team, then copy the filtered data to a new sheet.

Do that with the macro recorder on and you have most of the code that you need.