Forum Discussion
After cell input, move all rows 1 down
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.
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.