Untitled
unknown
plain_text
4 years ago
1.7 kB
5
Indexable
Sub Macro13() ' ' Sales_Entry Macro ' ' Range("B23").Select Selection.Copy Sheets("SalesList").Select Range("A5").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Sheets("SalesEntryForm").Select ActiveCell.Offset(1, 0).Range("A1").Select Application.CutCopyMode = False Selection.Copy Sheets("SalesList").Select ActiveCell.Offset(0, 1).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Sheets("SalesEntryForm").Select ActiveCell.Offset(1, 0).Range("A1").Select Application.CutCopyMode = False Selection.Copy Sheets("SalesList").Select ActiveCell.Offset(0, 1).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Sheets("SalesEntryForm").Select ActiveCell.Offset(1, 0).Range("A1").Select Application.CutCopyMode = False Selection.Copy Sheets("SalesList").Select ActiveCell.Offset(0, 1).Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Sheets("SalesList").Select ActiveCell.Offset(1, -3).Range("A1").Select Sheets("SalesEntryForm").Select ActiveCell.Offset(-3, 0).Range("A1:A3").Select Application.CutCopyMode = False Selection.ClearContents ActiveCell.Select End Sub
Editor is loading...