Forum Discussion

A.J .'s avatar
A.J .
Copper Contributor
Jun 08, 2018

After cell 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,
A.J.

Formulas & Functions
Need Help

2 Replies

  • Arul Tresoldi's avatar
    Arul Tresoldi
    Iron Contributor
    Jun 08, 2018

    I have something like that but:

    -I use google drive (modules) to insert new items to the list (you have to create a module asking for Day (if it's different from the date you add the idem), Item and Amount

    -then you link the results to a google calc page, and from there you have your table

    Just 1 problem: the last added item is at the bottom of the table

     

    Then, to have a better graphic experience you can add a sheet and work with INDEX & MATCH to recreate the table (all by formulas) in the way you want... it's not so easy to do so but let us know if it's ok for you. 

    • A.J .'s avatar
      A.J .
      Copper Contributor
      Jun 13, 2018

      Thank you Arul for your time.

       

      I am afraid your solution will not work for me.  The Excel file will be on a computer at work. There will be no Google accounts etc.  The computer is meant for employees and to manage and count the supplies.

       

      So the situations is very limited. 

      - Stand alone computer.

      - Limited internet connectivity / No accounts allowed.

      - One excel file.

       

Resources