VBA to make entry line

Closed
ace_ofgabriel Posts 4 Registration date Thursday September 24, 2009 Status Member Last seen September 30, 2009 - Sep 30, 2009 at 09:43 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Oct 5, 2009 at 06:44 AM
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 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Oct 5, 2009 at 06:44 AM
Hello

Just Record the steps, you will get the code
0