Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add a row
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to add a row
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. "Jenny Gleeson Ireland" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|