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:
please help me in the matter.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
thanks
surinder
[email protected]
Bookmarks