Hello,
I am new to macros and struggling to get a desired range, two adjacent columns (A7,B7), to autofill to the last row of C. Another problem is that I have some data throughout columns A and B and I do not want to overwrite those. So I think I need a loop to get around that?
<tbody>
</tbody><strike></strike>
My spreadsheet looks something like that and I want to be able to use this macro on other spreadsheets. I'm trying to get it to autofill say A2 and B2 down to C3, but then I need to autofill A4 and B4 to C6 and so on.
I am new to macros and struggling to get a desired range, two adjacent columns (A7,B7), to autofill to the last row of C. Another problem is that I have some data throughout columns A and B and I do not want to overwrite those. So I think I need a loop to get around that?
Title 1 | Title 2 | Title 3 |
Entry A2 | Entry B2 | Entry C2 |
Entry C3 | ||
<strike></strike> Entry A4 <strike></strike> | <strike></strike> Entry B4 <strike></strike> | Entry C4 |
<strike></strike> | Entry C5 | |
<strike></strike> | Entry C6 | |
<strike></strike> Entry A7 <strike></strike> | <strike></strike> Entry B7 <strike></strike> | Entry C7 |
<strike></strike> | Entry C8 | |
<strike></strike> | Entry C9 | |
<strike></strike> | Entry C10 |
<tbody>
</tbody>
My spreadsheet looks something like that and I want to be able to use this macro on other spreadsheets. I'm trying to get it to autofill say A2 and B2 down to C3, but then I need to autofill A4 and B4 to C6 and so on.