So you have
o) a listbox Click event
o) a decision depending on which item
o) to insert row(s)
o) to copy formulae
Do you have any of these done?

MarthaSue wrote:
User will choose an item from a list, by doing so, excel will insert one or
more rows depending on the item chosen . . .each row would have to be able to
have formulas in it as well . . .