Hello everyone I need your help. I have a table (d11 : o70) that has to be filled with values that are in a column in another spreadsheet. The first 12 results go to row 11 from column "d" to column "o", the next 12 to row 12 and so on up to row 70. I could do like this: Sheets("R_Branco_I5").Range("d11") = Sheets("D_socp_tts").Range("a2") Sheets("R_Branco_I5").Range("e11") = Sheets("D_socp_tts").Range("a3") But it was a very time-consuming process. My knowledge of VBA is limited. Can you help me solve this problem? Thank you all in advance for your attention. Luís

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA to Fill table with values from a column

Thread starter LuisVilarMoreira
Start date Jan 25, 2023
Tags

table vba

LuisVilarMoreira

New Member

Jan 25, 2023

Hello everyone

I need your help.

I have a table (d11 : o70) that has to be filled with values that are in a column in another spreadsheet.
The first 12 results go to row 11 from column "d" to column "o", the next 12 to row 12 and so on up to row 70.

I could do like this:

VBA Code:

Sheets("R_Branco_I5").Range("d11") = Sheets("D_socp_tts").Range("a2")
Sheets("R_Branco_I5").Range("e11") = Sheets("D_socp_tts").Range("a3")

But it was a very time-consuming process.

My knowledge of VBA is limited. Can you help me solve this problem?

Thank you all in advance for your attention.
Luís