Formula to add a row

[Jenny Gleeson Ireland]

I am familiar enough with excels formula - what ifs etc but I was wondering
if it is possible to construct the following formula:
I have an excel sheet full of everchanging contacts for customers including
company name, address, contact1, contact2, tel, fax etc. Some have more than
one contact others only the one contact. At the moment each company inhabits
one row and each additional contact for the companies are input on that same
row (ie no duplications of companies on different rows). I would like to be
able to create a formula that any additional contact once input on a company
row in a dedicated cell automatically inserts a new row and copies the second
contacts details into the new row along with the company name, address etc.
already typed on the original row. i.e any company with more than one contact
will have a dedicated row for each contact to include the same company name,
address etc.
I hope I have explained this enough, I don't know if it is even possible,
but would be nice to learn something new anyway!

 

[JLatham]

Jenny,
Two things that worksheet formulas cannot do:
physically add or delete rows or columns. Cannot hide/unhide them either.

This could (probably) be done with VBA code (a macro), but the chance of
success with that is dependent on how well structured the current information
on the rows is. If contact information always begins at a particular column
and occupies the same number of columns and a definite end point for contact
information, if other information comes after those entries, then chances are
very good. Barring that, if there are consistent column labels marking
contact information columns, chances are also good.