+ Reply to Thread
Results 1 to 4 of 4

Auto insert a row to keep consistent spacing

  1. #1
    Registered User
    Join Date
    02-19-2015
    Location
    usa
    MS-Off Ver
    excel 2010
    Posts
    18

    Auto insert a row to keep consistent spacing

    Hi,

    I would need help setting up an auto insert of a row.

    I'd like to have always 2 rows or more between groups of data without a manual insert. Right now any time I want to add a row bellow a group of data , I do insert a row and all the data is moved below, I would like to achieve what is shown on the jpeg.

    I will also have more cities added daily
    I will group data manually myself.
    If possible prevention of accidental deletion of a row,to keep the 2 row or more of consistent spacing, or a warning when trying to delete it by mistake with : DO you want to eliminate 2 row spacing yes/no.

    Thank you for your help.Autoinsert (Copy).jpg

  2. #2
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Auto insert a row to keep consistent spacing

    Use this macro in your sheet...

    Please Login or Register  to view this content.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  3. #3
    Registered User
    Join Date
    02-19-2015
    Location
    usa
    MS-Off Ver
    excel 2010
    Posts
    18

    Re: Auto insert a row to keep consistent spacing

    Thanks, but it doesn;t seem to work for me,
    I have macro enabled saved file,
    I inserted the code in a module,saved it, but no change when entering new names

    Any ideas what I'm doing wrong?

  4. #4
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: Auto insert a row to keep consistent spacing

    Yep, You need to enter the code into against the sheet rather than a separate module...
    Example.jpg
    Last edited by spitfireblue; 02-27-2017 at 05:09 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-26-2016, 12:38 PM
  2. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  3. Complex VBA problem auto insert date and time, auto insert comment, etc.
    By rojashan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 09:40 PM
  4. Rows Spacing, Column Spacing
    By Pukka83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2008, 12:05 AM
  5. Can I auto insert a worksheet when I insert a value in a cell.
    By iainc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-27-2006, 03:40 AM
  6. excel - auto spacing
    By Jerry Schlick in forum Excel General
    Replies: 2
    Last Post: 03-06-2006, 02:55 PM
  7. Auto Height Spacing in Cells nightmare!
    By cegreenway in forum Excel General
    Replies: 0
    Last Post: 01-04-2005, 04:19 PM

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