+ Reply to Thread
Results 1 to 2 of 2

Insert Rows Macro

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 365
    Posts
    149

    Insert Rows Macro

    Hi,

    I'd like to do the following with the attached file:

    1. Click 'ADD PRODUCT' button which will ask the user for the name of the new product and adds it to the last row of this list, e.g. 'Product E'.

    2. Click 'ADD PRODUCT DETAILS' which asks the user to pick an existing product and then adds a new row to the end of that product's rows.

    The attached file is just an outline of how the data could be arranged and is not set in stone...

    Any help would be greatly appreciated...
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,281

    Re: Insert Rows Macro

    Hi Lyla,

    Writing VBA code to do data entry is HARD. Adding the old Data Form tool to a worksheet is easy. See if this isn't a lot easier than what you are asking for.

    http://spreadsheets.about.com/od/dat..._data_form.htm
    http://www.addintools.com/documents/...data-form.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-12-2013, 04:56 PM
  2. [SOLVED] Macro code to insert 3 rows on spreadsheet with variable number of rows
    By D18GE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2013, 07:33 AM
  3. Replies: 0
    Last Post: 05-10-2013, 12:04 PM
  4. [SOLVED] Macro to insert blank rows so that the total number of rows with data is equal to 1021
    By nsm1411 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2013, 10:25 AM
  5. Replies: 2
    Last Post: 04-21-2011, 07:13 PM

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