Entering New Data from the TOP

[lzweifel]

Hi all,

I have a very simple spreadsheet but lots of data, 35,000 rows. Is there a way to enter data (new row) from the top?

 

[alansidman]

I would create a worksheet change event that inserted a new line at the specified row based upon input to a particular cell. Without detailed information, I cannot offer a more detailed response.

Additionally, you may need an workbook_open event to insert a new row at the specified row.

With more information, we could provide a specific code to allow this to happen.

 

[lzweifel]

Hi, how can you help me with this?

Meaning, what (how) do I send to you to show you want I have and need? Basically it is just at current 10 columns of data and 25,000 rows. I have the data sorted currently in alphabetical Order, which I don't think will matter. I have (working on) conditional formats for those rows, and would like to just go to the first row (row 3) and enter in data and have another populate able it for the next row.

 

[alansidman]

Assuming that you will be entering data continuously, ie. Enter a value in a row with the last entry in column 10, column J, then the following code should work for you.

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 10 Then
Range("A3").EntireRow.Insert
Else
End If
Exit Sub


End Sub