How do I use a button to insert a specified number of rows in a table?

Hello,

First of all I should say that I have extremely limited knowledge of VBA, so thanks in advance for any assistance and patience.

What I would like to be able to do is to use a button to automatically insert a number of rows in a table, copying formats, formulas and values to the new rows. The number of new rows inserted should be based on a value in a cell at the top of the worksheet. The worksheet would consist of an input cell at the top, button and then a table with header rows and the first row of the table (with formulas)

The process as I see it would work as follows:
1. Type a number into the input cell (say 50)
2. Click the button
3. Clicking the button then automatically inserts 50 rows (or rather 49 as the first row is already there) into the table, copying down formats, formulas and values.

I feel like this should be straightforward, but I don't know how to link the input cell to the button and then what code is used to get the button to insert the rows.

Thanks!

1 way would be pre-defining the input cell as say "A3" and basing your code around that. Your button could be placed anywhere and u could just assign the macro to it so whenever it is clicked, the macro starts.

Thanks poorcloud - the input cell is predefined. However, it's the coding that I have an issue with - as I said I'm really a beginner.

Is this what you mean?

Please Login or Register  to view this content.

Thanks for the quick reply again. It's not really what I mean though - that might solve part of the problem, but it wouldn't link to the input cell or the table.

Hi Norie,

Many thanks. Please see attached. I have added in comments on what I would like this worksheet to do. It would be great to understand how to make this work.

SolarPV.xlsx