If I could get some guidance in the right direction that would be great! I've spent a good 4 hours trying to figure this out.
My question is as follows: How would I go about making an empty "entry" row, that after being filled in would populate its cell data into the row below it?
While pushing down this row's data down one row , and that row's data down one etc..
Thus below the 'entry' row, there is a record of row 3's data arranged from newest to oldest
Row 3 needs to be blank (To be used for entry)
Line 4 will have data in it from the last time Line 3 was filled in
Line 5 will be the data from the time before line 3 was filled in
[line 3 gets filled out]
once all of row 3's columns are completely filled in
A new row is inserted above Row 4
Row 3 will copy its cell's data into this new Row 4
Row 3 will now clear, and wait for new entry