+ Reply to Thread
Results 1 to 3 of 3

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.
    Attached Files Attached Files
    Last edited by MattMax; 10-28-2017 at 09:55 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Insert line based on cell not line number

    Hi Matt & welcome to the forum. You will find you will get faster, more and better responses if you attach your workbook and at least some data. This means we won't have to attempt to recreate your data - possibly get it wrong - and will help us understand what you're trying to do. If you post your workbook, I'll take a look for you.

    MM.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

  3. #3
    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
    79,401

    Re: Insert line based on cell not line number

    MattMax - your other, duplicate thread has been closed. Please do not open duplicate threads on this forum. Thanks.
    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.

+ 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. 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
  2. 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
  3. 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
  4. [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
  5. Macro to insert new line after number increases
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2011, 10:51 PM
  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