I am retired banker having some knowledge of excel formulas. tried for GST bill
. First Macro is for clear the bill data and the second Macro is for saving the bill data in separate excel file. first Macro is working fine and the second Macro is creating a problem. Data for the second bill reflected in the proper row but when I am going for the third bill, data for the second row disappear.
the Macro is given below:
Sub SAVE_DATA()
'
' SAVE_DATA Macro
' SAVE BILL DATA
'
' Keyboard Shortcut: Ctrl+Shift+S
'
Range("B2:AC2").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveSheet.Paste
Application.CutCopyMode = False
Range("B3").Select
End Sub
please help me in the matter.
thanks
surinder
[email protected]
Bookmarks