| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically insert/delete rows to be x apart
Hi All,
I have a problem formatting an existing Excel spreadsheet into a format acceptable by a database which needs each NAME cell to be separated by 5 blank rows. I have the following fields... NAME, ID, ADDRESS, TELEPHONE/FAX/EMAIL, CONTACT, CODES (where there can be 1-8 rows of CODES for each NAME) Can anyone think of a way to automatically delete/insert rows (ignoring that there may be info in CODES), so that NAME is every 6 rows?? eg Bob 5 1 / 2 Rodeo Drive 5551245 Jane QWE Springfield ASD WA ZXC 76767 QAZ LKJ JHG OIU HUY Bob2 6 1 / 2 Rodeo Drive 5551245 Jane QWE Springfield WA 76767 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically hide rows with zero value | Excel Worksheet Functions | |||
| Can I use "find / replace" to automatically "Insert Rows" in a do. | Excel Discussion (Misc queries) | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| How do you automatically put spaces between rows in a lengthly w. | Excel Discussion (Misc queries) | |||
| How do I make Excel automatically adjust a row's height once I in. | Excel Worksheet Functions | |||
Threaded Mode
