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!