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

**ABSTRAKTUS** · 08-12-2010, 11:12 AM

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...

**JBeaucaire** · 08-12-2010, 11:33 AM

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.

**ABSTRAKTUS** · 08-12-2010, 11:57 AM

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...

**JBeaucaire** · 08-12-2010, 12:38 PM

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

**ABSTRAKTUS** · 08-12-2010, 02:16 PM

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?

**JBeaucaire** · 08-12-2010, 04:27 PM

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.