+ Reply to Thread
Results 1 to 3 of 3

Insert line according to cell value not line number

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

    Insert line according to cell value 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
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164
    Hello MattMax,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,301

    Re: Insert line according to cell value not line number

    You should post your questions in the question section. this section is for chit chat so you are attracting completely the wrong people.

    you want the vba section of the forum.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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: 12
    Last Post: 06-22-2016, 01:11 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