Hello Experts,
Greetings. I am thankfull for all the supports you provide. As usual, I need your support to generate a macro.
I have Sheet1, in which Cells D14 to C20 are the targets. If any of these cells changes, I want to run the following macro.
Sub Button11_Click()
'
' Button11_Click Macro
' Macro recorded 12-25-2013 by gmk
'
' Keyboard Shortcut: Ctrl+f
'
ActiveWindow.SmallScroll Down:=-9
Range("C14:D20").Select
Selection.Copy
Range("C31").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Selection.Sort Key1:=Range("D31"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub
Can you please help me. My sincere thanks for all experts.
Should I paste your program in the Module / Worksheet or in the Workbook?
Regards,
gm2612
Bookmarks