VBA to make entry line [Closed]

Report
Posts
4
Registration date
Thursday September 24, 2009
Status
Member
Last seen
September 30, 2009
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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

Example)
[start]
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

Thanks

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello

Just Record the steps, you will get the code