Untitled
unknown
plain_text
4 years ago
1.7 kB
11
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...