Results 1 to 3 of 3

Insert row automatically with correct format and drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Insert row automatically with correct format and drop down list

    Hey,

    I am currently working on a spreadsheet which I have to add 2 rows every 44th row.

    I would like to insert 2 rows between rows 29 and 30. The first row has to contain data but the second added row is meant to stay blank (although it would require to maintain the formatting)

    On the first row to be added, the data is
    Column A - Blank
    Column B - Fatal Issue (Yes/No)
    Column C - Drop down list linked to sheet 1 (called '1. Criteria', the cells in the list are B66 and B67)
    Column D - If Yes, explain it in the Comments section

    I need these rows inserted every 44th row (so, the first two rows will be inserted between rows 29 and 30, the second two rows will be inserted between 73 and 74 the third between 117 and 118 and so on for about 5000 rows but I will have to add more data later on, so it will probably get up to 10000).

    I assume a macro could do this, but I have zero skills. Could anyone help me out with this issue? ANy help would be greatly appreciated.
    Last edited by exclaymation; 05-20-2013 at 12:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1