Search : in
By :

VB code for Excel (Simple Question)

ace_ofgabriel, on Sep 25, 2009 3:40:36 pm BST 
 Report this message to moderators

What would the VB code be if I wanted to have an empty "entry" row, that would populate its cell data into the row below while pushing down its data under it, 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
MS Office 2007
Firefox 3.0.10

Best answers for « VB code for Excel (Simple Question) » in :
VB code for copy data from one excel sheet to Show
Connecting vb to database Show
Connect a database (MDB) to excel Show [VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Adding a VBA CommandButton with its respective the code ShowAdding a VBA CommandButton with its respective the code Paste these two sub in a general module (Module1 for example). Sub CreateButton() Dim Obj As Object Dim Code As String Sheets("Sheet1").Select 'create button ...
Repainting a cell using excel VBA ShowRepainting a cell using excel VBA Issue Solution Note Issue I am writing a code in excel VBA to generate a report.I am totally new to VBA.Here's my code Private Sub CommandButton1_Click() Dim a1 As Integer Dim d1 As Integer Dim...
Windows Error Codes and How to Fix them ShowWindows Error Codes and How to Fix them Below is a list of the most common error codes that you an face while using Windows and its basic components. Some solutions have been provided for you to try to solve them. You should also note that...
Download Excel Utility Show
Download OfficeFIX Office Data Recovery Show
Download CDXStreamer ShowDescription The application is designed by Hughes Financial Services, Inc. CDXStreamer is an add-in for Microsoft Excel. Simple and easy to use, the application has been awarded from various places. CDXStreamer enables you to make several requests to...
Substitution cipher ShowSubstitution cipher Substitution cipher involves replacing one or more entities (generally letters) in a message with one or more other entities. There are several types of substitution cryptosystems: Monoalphabetic substitution involves...
ASCII Code ShowData coding Morse code was the first code used for long-distance communication. Samuel F.B. Morse invented it in 1844. This code is made up of dots and dashes (a sort of binary code). It was used to carry out communication much faster than could...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply
They need your help