+ Reply to Thread
Results 1 to 6 of 6

To assign MACRO to the button to insert rows (shift cells down)

  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    607

    To assign MACRO to the button to insert rows (shift cells down)

    Hi all,

    In my workbook I have about 20 products going down. Next to each product I have a button. So, whenever I click it, I want a row with the same formating to appear underneath a product.
    See attached...
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: To assign MACRO to the button to insert rows (shift cells down)

    By cleaning out the merged rows and resorting to simpler row height adjustments, you can turn on the LIST feature on each of these tables, it may be called TABLE feature in Excel 2007.

    Anyway, once the merge rows are removed, click in a data table and pressing CTRL-L offers the LIST-wizard. I've already activated the LIST/TABLE feature for the 3 tables on sheet3.

    Now any time you click inside any of the data sets, Excel offers you a new expansion row for the table. As soon as you type anything in the expansion row, that row becomes permanent and a new expansion row is offered.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    607

    Re: To assign MACRO to the button to insert rows (shift cells down)

    Well. Probably I wasn't clear with my request. Under each product will be only one line for entry. But sometimes more than one entry will be required. I want users to click a button to insert another line when required.

    P.S. Your redone workbook doesn't work for me for some reason...

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: To assign MACRO to the button to insert rows (shift cells down)

    Your profile says Excel 2003, but you uploaded an xlsx file, Excel 2007. Try this version.
    Attached Files Attached Files

  5. #5
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    607

    Re: To assign MACRO to the button to insert rows (shift cells down)

    It works. But it is not exactly what I am looking for. Idea is good. But these 20 tables (one for each product) have to be in the worksheet at the beginning of entering information. And entries will be made randomly. Entry can be made on 3rd product, then 15th, then 10th and then back on 3rd again. and lines cannot appear if there is a table below. Any idea?

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: To assign MACRO to the button to insert rows (shift cells down)

    You haven't explained how the suggestion given doesn't work. You can start a new product table at any time below the ones already there and then CTRL-L to turn it into a self-growing list.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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