How to insert blank row below

**kulahblind** · 06-12-2012, 05:55 PM

Hello All,

New to the forums and I currently have a dilemma.

I've attach a link to my excel spreadsheet. (.xlsm & .txt w/ VBA code) Excel 2010

Blu-ray_Firmware_InsertRowsVBA_Help.zip
[VBA Code pulled from] http://www.excelforum.com/excel-prog...ific-text.html

Under each player model there is a button titled "Add New". the columns to the right (Firmware, Date Updated, and Updated By) are the history of update versions and when they occurred and who updated them.

The versions will be entered in DESC order. (Most recent updates on the top, not sorted, manually entered)

I have filled the Make / Model row's in as white. The others rows (older versions of firmware) are 2 shades of grey.
When I click the "Add New" button, I would like the macro to insert a row below the white "Make / Model" row with the same formatting as the grey rows, and once the new row is created the values should be blank so I can enter the new version.

What would be even better is if I click the "Add New" button, a new row is inserted below the White "Make / Model" row with the grey row formatting and is populated with what USED to be in the white row just before i clicked the "Add New" button. That way the White (most current version / new version) can be entered and the older version is automatically archived to the newly created grey row below. I'd like each "Add Asset" button to be "tied" to the same player the button corresponds with. Meaning each individual Blu-ray model will have an "Add New" button. I'm sure this plays a big factor on the VBA code.

I apologize if this is all cluttered. Let me know if you are able to assist or need more clarification as the above may be somewhat hard to understand.

[referenced thread] http://www.excelforum.com/excel-prog...ific-text.html

[EDIT] I tried using the "Record Marco" feature but I need to do this for multiple rows on several worksheets and not just a single row which will eventually change.

Thanks in advance!

-KB

**kulahblind** · 06-14-2012, 01:17 PM

Any help on this subject would be greatly appreciated! I'm currently at a stand still and cannot move forward with this document and it's for my job

[REVISION] After looking over my workbook, I'm thinking there may be a better solution.

[INTENDED FUNCTION] Basically I have a button that says "Add New" underneath the white "Make & Model" row. Each blu-ray player will have an "Add New" button associated with it.

When the "Add New" button is clicked, I want a dialog box to pop up asking what the "New Firmware Version" is and the user inputs the new version.
Once the "New Version" has been entered, a second dialog box will pop up asking for the "Date Updated", and the user inputs the date it was updated.
A third dialog box will then pop up and ask for the "Updated By" which will be a first name and last initial.

Once these 3 values have been entered, I would like excel to insert a row beneath the white "Make & Model" row associated with it, and to populate the new greyed out row with the previous information stored in the white "Make & Model" row. (Firmware [column J], Date Updated [column K], Updated By [column L]), and the new version information that was just entered should auto-populate the white "Make & Model" row. This needs to function for multiple player models across multiple sheets within the same workbook.

Thanks again!
-KB