This code is updating a summary sheet but now I need to tweak it a little to grab just a portion from another sheet but do the exact same thing? How do I make it look at sheet summary 2 ?? I'm not very good at vba and would really appreciate any ideas -- thank you!!!
If bAddSupport Then
target.Offset(2) = "Support"
With ws
With .Range(.Range("B10"), target.Offset(, 8))
target.Offset(3).Resize(.Rows.Count, 9).Value = .Value
With target.Offset(3, 4).Resize(.Rows.Count, 4)
.FormulaR1C1 = "=R[-" & .Rows.Count + 2 & "]C * Support"
End With
Bookmarks