Hi, I am VBA Excel coder since yesterday and I am stuck. Hopefully you can help me.
I am managing sports team and want to follow players training progress.
I have made google forms page and linked it's workbook to my computers excel file to update it automatically via Data - New Query - From Web.
The Data comes in like this
<colgroup><col span="2"><col><col span="3"><col></colgroup><tbody>
</tbody>
The data will come in as above written. I want to write a code that looks at column 4 to fine needed condition. I have different sheets for each players, so Player1 data would copy to sheet Player1 and so on.
Best would be to copy only column 4-7 data, because I don't need first threes, but I can hide them as well, so entire row could work too.
Problems that I have discovered with different codes
Rows copy again and again - I triggered copying with active button, but it copied old data as well. I need new imported rows only.
Data copied as text - I would prefer numbers, so I can make graphics immediately. Now I need to format cells always.
I am managing sports team and want to follow players training progress.
I have made google forms page and linked it's workbook to my computers excel file to update it automatically via Data - New Query - From Web.
The Data comes in like this
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 |
1 | Timestamp | Name | XXXX | YYYYY | ZZZZZ | |
2 | 15/11/2019 14:12:02 | Player1 | 1 | 4 | 3 |
<colgroup><col span="2"><col><col span="3"><col></colgroup><tbody>
</tbody>
The data will come in as above written. I want to write a code that looks at column 4 to fine needed condition. I have different sheets for each players, so Player1 data would copy to sheet Player1 and so on.
Best would be to copy only column 4-7 data, because I don't need first threes, but I can hide them as well, so entire row could work too.
Problems that I have discovered with different codes
Rows copy again and again - I triggered copying with active button, but it copied old data as well. I need new imported rows only.
Data copied as text - I would prefer numbers, so I can make graphics immediately. Now I need to format cells always.