Results 1 to 5 of 5

Need help for inserting rows & worksheets on button click using VBA

Threaded View

saket_47 Need help for inserting rows... 10-31-2014, 04:31 AM
natefarm Re: Need help for inserting... 10-31-2014, 05:32 PM
saket_47 Re: Need help for inserting... 11-02-2014, 11:27 PM
natefarm Re: Need help for inserting... 11-03-2014, 11:13 AM
saket_47 Re: Need help for inserting... 11-03-2014, 11:45 PM
  1. #1
    Registered User
    Join Date
    10-31-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    11

    Need help for inserting rows & worksheets on button click using VBA

    Attached - Workbook_001.xlsm (for reference.)

    Hi, I am novice in VBA application for Excel.
    I need your help in creating VBA (.xlxm) file that will do tasks as detailed below.

    i) The Workbook contains One “Summary” sheet & one “Master” sheet.
    “Summary” sheet has table with Serial number, reference No., Description etc.
    “Master” sheet will be used for making duplicate multiple copies as required.
    ii) On click of a button placed in “Summary” sheet, -
    1. One Row should get added to the table with automatic Next serial number & Next Reference number in series.
    2. After Row is added to the Worksheet, “Master” worksheet should make a copy of itself at the end of all worksheets.
    3. This newly added Worksheet should be renamed to Reference number from Row added in “Summary” sheet
    4. Defined Cells (e.g. A2 or B2 etc) inside this newly added worksheet should reflect values from newly added row in Summary sheet.
    (i.e. Serial Number & Reference Number generated in Summary sheet should also go into Copied Master sheet at specified cells (A2,B2)
    5. After the text is manually entered in “Description” column of “Summary” sheet, it should reflect in respective duplicated “Master” Worksheets at specified cells (C2)
    6. If possible, I want to keep “Master” Sheet hidden.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to clear contents/delete rows on click of button
    By murchy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2013, 09:11 AM
  2. Command Button to change the subsequent rows with each click
    By sand_electro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 04:13 PM
  3. inserting rows with submit button
    By den88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2010, 06:18 PM
  4. Printing worksheets with a click of a button?
    By ivwshane in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2008, 05:11 AM
  5. copy 45 rows down, repetativly, only on button click?
    By foxgguy2005 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2005, 11:06 AM

Tags for this Thread

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