SirAsksAlott
New Member
- Joined
- Aug 21, 2014
- Messages
- 7
Completely new at VBA, having fun learning though. I'm trying to automate reports at the office, and I'm having an issue particularly with looping a specific process. Here's what I have so far:
What i'd love to do is loop paste one column, and then continually paste that column over entire columns to the right until "YTD" is located at the 3rd row of the next column, and then to stop. This report will continuously add a new week, so the column YTF will continually move over one to the right every week, so it has to be a dynamic loop that will check for that.
Thanks
PHP:
Sheets("Attach Rate").Activate
Range("F1").EntireColumn.Insert
Range("E:E").CopyIf Range("F3").Value <> "YTD" Then
Range("F:F").PasteSpecial xlPasteAll End If
Range("F:F").Copy
If Range("G3").Value <> "YTD" Then
Range("G:G").PasteSpecial xlPasteAll
End If
What i'd love to do is loop paste one column, and then continually paste that column over entire columns to the right until "YTD" is located at the 3rd row of the next column, and then to stop. This report will continuously add a new week, so the column YTF will continually move over one to the right every week, so it has to be a dynamic loop that will check for that.
Thanks