My macro currently looks like this:
Sub Day1()
'
' Day1 Macro
' Macro recorded 6/20/2006 by Matt Lance
'

'
Range("V7:V28").Select
Selection.Copy
ActiveWindow.SmallScroll ToRight:=-7
Range("D7").Select
ActiveSheet.Paste
End Sub

What I want to do is have it so that instead of selecting D7 to paste, I want it to select the same column that the command button is in and then the 7th row. This way I can have one macro used across several buttons instead of having a macro for every column I use.

Does anybody have any suggestions??