Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting Rows
Please forgive me for any newb mistakes.
I have an Excel document with ~300 rows of data. I have found that I need to add 5 rows to each existing row (each of these rows contains the same data). Is there a macro I can build to do this? Example: 1. Joe California Dog House 2. Kim Georgia Cat Apartment .......etc For each row (1 through 300) I need to add 5 rows (Phone, Spouse, Children, School, Degree). I can obviously Copy-- Insert copied cells, but that requires me to manually do so for ~300 rows, re-copying for each new insert (UGH). The end sheet would look like: 1. Joe California Dog House 2. Phone 3. Spouse 4. Children 5. School 6. Degree 7. Kim Georgia Cat Apartment 8. Phone 9. Spouse 10. Children 11. School 12. Degree ......etc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting rows inbetween rows of data ? | Excel Discussion (Misc queries) | |||
Copying & Inserting Rows w/o Affecting other Rows Etc. | Excel Worksheet Functions | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
inserting rows | Excel Discussion (Misc queries) | |||
Inserting Rows | Excel Worksheet Functions |