Untitled

 avatar
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...