+ 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
    Earth
    MS-Off Ver
    2019
    Posts
    721

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,030

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite 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. Insert Line maintaining formatting and formulas from preceding line
    By mangled_us@yahoo.com in forum Excel General
    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