+ Reply to Thread
Results 1 to 3 of 3

After input move all rows down

  1. #1
    Registered User
    Join Date
    02-24-2022
    Location
    Turkey
    MS-Off Ver
    2016
    Posts
    2

    After input move all rows down

    Hello everyone,

    I have a sheet with a fixed top row and columns A to P. I want to leave the second row blank to input some data. After I input my last data in P2 this row will move down and the second row will be blank again. I've seen a similar problem that is solved with the code below. But this code doesn't make the cell move down which the data is inputted in the target column.

    Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: After input move all rows down

    That code is specifically looking at 'Target.Column = 4', which is column D. You can probably just use the following macro instead:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-24-2022
    Location
    Turkey
    MS-Off Ver
    2016
    Posts
    2

    Re: After input move all rows down

    It works, thanks a lot.

+ 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. After input, move all rows 1 down
    By Arjan35 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 08-20-2021, 08:49 PM
  2. Move/Copy/Insert rows within a range of input rows
    By Warbe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2019, 09:36 AM
  3. After input, move all rows 1 down
    By Arjan35 in forum Excel General
    Replies: 1
    Last Post: 06-07-2018, 11:19 AM
  4. [SOLVED] Macro to Move Rows to New Worksheets Based on Criteria & Then HIDE & Move Back
    By abro0821 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2014, 04:00 PM
  5. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  6. Move Rows Based on Cell Input
    By aegliveinterns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2010, 02:08 PM
  7. Move rows to another sheet based on column input
    By lacerz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2010, 01:02 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