Hi,
The thread title may be incorrect for what I'm after, as I don't know the proper terms or keywords to address my issues.
My Aim: I will have multiple rows of data which I would like converted into a pre-made template form to be printed (similar to an invoice).
Essentially I am trying to make a 'match card generator' for a soccer tournament.
Ideally, the steps involved are:
1. Copy-paste the relevant fixtures data from each competition into excel.
2. Add in appropriate data to complete each row
3. Each row needs to 'automate' and convert itself onto my Match Card template.
4. I'd like one row of data to fill out onto one match card. i.e. each row is a separate entity, thus I will need 8 match cards generated for my example worksheet.
I have attached a screenshot of my workings thus far. I'm willing to learn how to script macros or perform other procedures to try and make this work.
To indicate exactly what I have copy-pasted from the fixtures website, I've highlighted each paste in a different colour. The non-highlighted content is manually entered, but can easily be transformed into formula-dependant cells to quicken the process.
Please, please help. I am willing to be very patient to ensure this can work.
Match Card template \1
Fixture List Raw Data \1
Bookmarks