Excel - creating optional rows?

[Cyclist33]

I've got this spreadsheet with items down the left (in column A) eg Road bike; MTB; hybrid. Then across the top in columns B C and D I've got: Type (which is a picklist of wheel size either 26" or 700c); Condition (picklist Old or New) and column D is Value in £.

If I had this spreadsheet fully populated, and then say bought another road bike, I would add a row in under the existing Road bike row (row B) and copy the picklists down then pick the relevant options in each picklist.

What I would love to do is, have an option for the user of the spreadsheet to say, click a button which would create a new row automatically and fill it up with the picklists etc, so that the user doesn't need to know how to create rows manually or bother copying n pasting.

Can it be done?

Thanks

Stu

 

[Markymark]

Very easily using a Macro.

Once learnt, Macros can add much much more to Excel but there is quite a learning curve. Google for some basic tutorials to get you started.

 

[Shut Up Legs]

Another tip: you can create a basic macro simply by using Excel's recording function. In other words, you

• turn recording on;
• do all the actions required to create the new row and copy stuff from the other rows;
• stop the recording; then
• open up the Visual Basic editor window in Excel, and modify the macro as needed, e.g. write a subroutine to be called from a button.

As Mark said, you'll need to do some web searching to get the basics, but there's numerous useful examples on the web to get you started .