Macro to auto fill rows based on one cell value

Hi,

I am trying to create a macro to insert and fill in whole rows based on where one cell has a value in it. I have a huge spreadsheet and need to create a summary one based on the items selected on it. So where a row is filled in with a number of items, it should appear on the other sheet, but not those where the number of items is blank. There is header/footer info so I don't want lots of blank lines which is why I thought a macro would be better than a formula, but I'm hoping someone with more expertise than me could advise!

Example attached.

Thanks (again)

No VBA needed. Add a simple "key" column to your first sheet (and hide it if you wish), then normal worksheet formulas can construct your table in realtime.

There are two formula, colored to show which sections has each.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Like so...it's pretty much the exact same thing, but instead of indexing all of column A, we index "sections".