This is for a pro - Automatically Insert a Number of Rows Starting Down a Specified Row
Posted by Oeloel on August 05, 2000 7:04 AM
Suppose you want to Insert 24 rows not inmetiately after the row where the active cell is but below (down another 24 rows) where you want to add a person's data. Each person should have 24 rows for the user to enter data corresponding to 24 weeks. I want to not only insert those 24 rows but also automatically have those rows be formated with the formating of the preceeding 24 rows that belongs to the previous person's data where the active cell was. I also want all the formaulas of thaose rows be added to the inserted 24 rows. Is my request easy to understand?