Results 1 to 3 of 3

how to save multiple columns data from one excel sheet to another using Macro

Threaded View

  1. #1
    Registered User
    Join Date
    08-26-2017
    Location
    INDIA
    MS-Off Ver
    OFFICE 7
    Posts
    1

    Post how to save multiple columns data from one excel sheet to another using Macro

    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]
    Last edited by sbv782; 08-28-2017 at 01:16 PM. Reason: admin adviced

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to add another Macro to a button to add into a larger Macro.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2016, 10:51 AM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  4. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  5. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  6. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  7. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1