So, I've built the macro and it works like I want. However, instead of selecting the Columns("O:O"), I need it to paste in the active cell, or preferably in the next free column. How would I use the activecell object in this case? I'm sorry - my VBA is very rusty.
Sub AddGoal()
'
' AddGoal...
I have a workbook with several sheets related to customer transactions. On one sheet (Customer) is a table that has just the customer code and name, then on another sheet is a list of goals. For each customer there is a column for Goal, Actual and Difference. Then there are 4 difference goals...