Search : in
By :

VBA to make entry line

Last answer on Oct 5, 2009 11:44:32 am BST ace_ofgabriel, on Sep 30, 2009 2:43:56 pm BST 
 Report this message to moderators

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

Configuration: Windows XP sp3
Firefox 3.0.10

Best answers for « VBA to make entry line » in :
Make an ISO image Show Make an ISO image What is an ISO image? How to create an ISO image How to burn an ISO file to a CD-ROM/DVD-ROM What is an ISO image? An ISO image is created by a particular software and is the replica of an existing file system. This...
Creating an ISO image under Linux Show Creating an ISO image under Linux Create ISO image(which we will name) a disc in a CD-ROM drive(/dev/cdrom) is quite simple : dd if=/dev/hdd of=mycd.iso
Publish a PDF file on your website Show Publish a PDF file on your Website Displaying a link to a PDF on your Website Displaying the PDF on your website Displaying a link to a PDF on your Website Proposing a PDF link on your own website is an operation that can seem...
How to create your own Website ShowHow to create your own Website What is HTML? Example 1: HTML Tags HTML Elements Basic HTML Tags to Remember Example 2 HTML Attributes and Values Example 3 Colour Tags Example 4 Text Formatting Example 5 HTML Division Tags Example...
Inserting an image in gmail when composing a message ShowInserting an image in gmail when composing a message Here is a great way to insert images in your Gmail e-mails. Guaranteed results! Since you have a Gmail account (since you ask this question) you need access to Google Docs. This...
Print Screen (Windows, Mac OS X and Unix/Linux) ShowHow to make a Print Screen (Windows, Mac OS X and Unix/Linux) What is a Print Screen? How to make a Print Screen (Windows) How to make a Print Screen (Mac OS X) How to make a Print Screen (Unix/Linux) Screen Capture Softwares What is a...
Download Blogspreading ShowBlogspreading will help you spread your blog around the world. Make a link to your messages and get a lot of new readers. Advantage It automatically adds a link to the last post in your blog to your e-mail. It allows recipients to easily...
Download Windows Movie Maker ShowDescription: Windows Movie Maker is surprisingly easy and amusing for family realization of films, by allowing you to create, to edit and to share your films on your own computer by of simple slip move. You can add special effects, music and...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
UNIX system - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence its name "shell". The shell therefore acts as an intermediary between the operating system and the user using command lines...

1

 Excelguru, on Oct 5, 2009 11:44:32 am BST

Hello

Just Record the steps, you will get the code A wise man once said, 'I complained that I had no shoes unti­l I met a man who had no feet.'
I am interested in financial Modelling and custom excel deve­lopment with excel macros.

Reply to Excelguru