Closed Thread
Results 1 to 2 of 2

Insert line based on cell not line number

  1. #1
    Registered User
    Join Date
    10-26-2017
    Location
    Anniston, AL
    MS-Off Ver
    15
    Posts
    2

    Insert line based on cell not line number

    Please Help

    I'm trying to set up a spreadsheet with 30+ sheets, and I need to make it so an inserted line goes in line with dates. if sheets one inserts a line at "3:3" then sheets 2 adds line to "4:4" they will be out of order. if sheet 1 doesn't add a line and sheet 2 does then they line up. I'm trying to find a way to set it so if column b has value of 6 that's where the line inserts, instead of line 6. If anyone can help it would be greatly appreciated.
    Please Login or Register  to view this content.
    I have it almost complete, but i'm stuck.
    P.S. this line of code is for one sheet only, I have adapted versions for all 30+ sheets.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Insert line based on cell not line number

    Duplicate threads are not allowed. Continue here, please: https://www.excelforum.com/excel-pro...ne-number.html

    The forum rules, to which you agreed upon joining, are here for you to review: https://www.excelforum.com/forum-rul...rum-rules.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Insert line based on cell not line number
    By MattMax in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2017, 10:05 AM
  2. Insert line according to cell value not line number
    By MattMax in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 10-26-2017, 10:15 PM
  3. Insert line and copy data of previous line with certain changes
    By vijayca in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2016, 07:19 AM
  4. VBA - To insert line reading the number on cell
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2013, 10:24 AM
  5. [SOLVED] Where more than 1 line exists in excel transfer - insert line in word report bookmark
    By PippiLaRue in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2013, 05:04 AM
  6. Insert Line Every Other Row w/Multiple Formulas based on Line Above
    By xyshel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2011, 11:09 AM
  7. Replies: 8
    Last Post: 11-30-2005, 09:55 AM

Tags for this Thread

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