Hello!
I've been working on this for what seems like days. Ultimately, I'm wanting to know how to quickly grab data from a link via Web Query, then edit that data with a script or macro. End goal is to identify fantasy football draft trends:
Web Query: Completed Draft - Fantasy Football Calculator
Results look like:
<tbody>
</tbody>
Whereas the preferred edit would be:
<tbody>
</tbody>
I understand that =CONCATENATE(A1, " ", A2, " ", A3) will accomplish this, however as you can see from the table, the editing for each query will take a long time as there is typically 450 cells to edit AND if the formula is dragged, it will add A2, A3, A4 on the next cell, instead of A4, A5, A6. Is there a script that I can add which will quickly combine cells as mentioned above? And is there a way to automate this process where say it will go to this site(Completed Mock Drafts - Fantasy Football Calculator) and grab the first 5 or 10 and create a new work sheet for each?
I know it can be done, but I know next to nothing about coding.
I am a first time poster, I was unable to access the etiquette page prior to posting. If these should be reformatted, I will happily do so.
I've been working on this for what seems like days. Ultimately, I'm wanting to know how to quickly grab data from a link via Web Query, then edit that data with a script or macro. End goal is to identify fantasy football draft trends:
Web Query: Completed Draft - Fantasy Football Calculator
Results look like:
| Jamaal | Arian | LeVeon |
| Charles | Foster | Bell |
| RB (KC) 9 | RB (HOU) 9 | RB (PIT) 11 |
| LeSean | Matt | Andrew |
| McCoy | Forte | Luck |
| RB (BUF) 8 | RB (CHI) 7 | QB (IND) 10 |
| Alshon | Mike | T.Y. |
| Jeffery | Evans | Hilton |
| WR (CHI) 7 | WR (TB) 6 | WR (IND) 1 |
<tbody>
</tbody>
Whereas the preferred edit would be:
| JAMAAL CHARLES RB (KC) 9 | ARIAN FOSTER RB (HOU) 9 | LEVEON BELL RB (PIT) 11 |
| LESEAN MCCOY RB (BUF) 8 | MATT FORTE RB (CHI) 7 | ANDREW LUCK QB (IND) 10 |
| ALSHON JEFFERY WR (CHI) 7 | MIKE EVANS WR (TB) 6 | T.Y. HILTON WR (IND) 10 |
<tbody>
</tbody>
I understand that =CONCATENATE(A1, " ", A2, " ", A3) will accomplish this, however as you can see from the table, the editing for each query will take a long time as there is typically 450 cells to edit AND if the formula is dragged, it will add A2, A3, A4 on the next cell, instead of A4, A5, A6. Is there a script that I can add which will quickly combine cells as mentioned above? And is there a way to automate this process where say it will go to this site(Completed Mock Drafts - Fantasy Football Calculator) and grab the first 5 or 10 and create a new work sheet for each?
I know it can be done, but I know next to nothing about coding.
I am a first time poster, I was unable to access the etiquette page prior to posting. If these should be reformatted, I will happily do so.
