I have a spreadsheet that contains a table, and I am working with a VB macro to update a row each week. The below works for the correct columns and rows, but it updates the columns outside of the table. I have tried with no success to utilize ListObjects("Table4") to make the range available within the table but have failed miserably. Any direction would be much appreciated!
Sub Update_Sheets()
Sub Update_Sheets()
With Sheets("Sales Summary")
.Range("T" & Rows.Count).End(xlUp).Resize(2, 6).FillDown
.Range("C" & Rows.Count).End(xlUp).Resize(2).FillDown
.Range("C" & Rows.Count).End(xlUp).Resize(2).FillDown
End With
With Sheets("Other Sales Summary")
.Range("T" & Rows.Count).End(xlUp).Resize(2, 6).FillDown
.Range("C" & Rows.Count).End(xlUp).Resize(2).FillDown
.Range("C" & Rows.Count).End(xlUp).Resize(2).FillDown
End With
End Sub