Macro/VBA to Add Rows based on presence/absence of specific text content

Hello all,

I'm struggling with a problem, that I assume a macro would fix, and would appreciate any advice you can provide.

I have an existing spreadsheet of building material data. The first two columns are a Location # and Location Name. The third column over is called "System", and contains entries like "Floor, Wall, Ceiling, etc.

I need to add new rows when a Location Name/# combo exists, but there are no existing rows for System = Floor, Wall, Ceiling, Pipe or Structure. There are 6 other columns to the Right of the System Column, and the leftmost five ideally need to be filled out with the text "N/A". An example new row entry would be (semicolons denote new column): A-01; Corridor; Floor; N/A; N/A; N/A; N/A; N/A; ; (sixth column is left blank)

Again, really appreciate any help anyone can provide.

I've attached an example file with the new entries added manually

I'm working with Excel 2010 if that makes a difference.