Good Evening, I'm still fairly new to VBA and my googling hasn't gotten me results. I'm trying to move data from 3 columns to a different 3 columns, same workbook and sheet, even the same row. The column data is being moved to depends on what is in the first column, from what I can tell this requires a Case statement. I've entered 3 of the values in my code so far and when I run the macro nothing actually happens. See code below.
This is the desired outcome:
<tbody>
</tbody>
This is where I was getting my information from and I'm sure it's lacking context that I'm not able to determine: https://www.techonthenet.com/excel/formulas/case.php
Code:
Sub MoveTax()
Select Case Column1
Case "CA1"
Range("A:C").Cut Range("D:F")
Case "PA12"
Range("A:C").Cut Range("G:I")
Case "PA10"
Range("A:C").Cut Range("G:I")
End Select
End Sub
This is the desired outcome:
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 |
CA1 | $3 | $8 | here | here | here | |||
CA1 | $5 | $7 | here | here | here | |||
PA10 | $8 | $9 | here | here | here | |||
PA12 | $13 | $19 | here | here | here |
<tbody>
</tbody>
This is where I was getting my information from and I'm sure it's lacking context that I'm not able to determine: https://www.techonthenet.com/excel/formulas/case.php