Closed Thread
Results 1 to 2 of 2

After input, move all rows 1 down

  1. #1
    Registered User
    Join Date
    06-07-2018
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    5

    After input, move all rows 1 down

    Hello everyone,

    I am trying to help a friend create her Excel sheet. We are both sort of new to Excel but eager to learn.
    As far as I read on internet searches, the solution might involve a Macros of sorts? I am hoping it could be solved in a easier way.

    The situation:
    Every day new items arrive in the store. We input the day, the item type and the amount.
    The next day new items arrive. Over time this list will grow
    This list is only for keeping a record of what came in everyday


    Question:
    Is it possible, to have 3 cells on top of the sheet. This is where we input our data. Then, we press Enter, or a button of sorts. And the new data will be moved one row down, along with the rest of the data in the sheet. (we do not want to manually insert a row. We have co-workers that are computer illiterate and we want to make it as simple as we can for them.)

    So the data on row B6,C6 and D6 will move to B7. C7 and D7 (and etc, all the other data below it will also move one row down.).
    Will formulas in the cells also move down and adjust their values?



    I have attached an example file. (This is made in Openoffice-Calculator as I do not own a copy of Excel). My friend does own Excel. 2013 or 2016.


    Thank you for your time,
    Arjan
    Attached Files Attached Files

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: After input, move all rows 1 down

    Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

    Thread Closed.
    HTH
    Regards, Jeff

Closed 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. [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
  3. [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
  4. Replies: 2
    Last Post: 08-27-2013, 05:01 PM
  5. have reference cells move in rows while I move in columns
    By gryffin13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2011, 09:33 AM
  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