General question about auto- adding first row?

[indygo]

Is it possible to record a macro to add new ROW after each entry?

This could be useful when we have a long list ordered by date and we have New items on top.


a1: title
a2: Empty (and adding new row here)
a3: first data row.


is is possible? because going down the list to cell number 23000 is a bit annoying.

 

[James006]

Hi,

With Excel ... everything is possible ...

Do you mean you would like to have a row automatically inserted ...?

If yes ... when should this happen ...???

 

[indygo]

Hmm tricky question. Set's say you have one empty cell on top of a long list and you have copied 10 rows.
You select the cell and do ctrl+V and it adds 10 rows without removing the ones below.


Initialy I had automatic web scraping in mind and updating records so that new items would be on top.

 

[James006]

Hi again,

If the actual problem is to have "new items on top" ... there is no need to insert any row ... but to have an automatic sort ... :wink:

 

[indygo]

Yes but sorting is different. As I understand I would still have to paste in the last row and THEN sort. But I want to avoid that. Just paste on top and make space for enough rows to be pasted.

 

[wornhall]

Try this:

        Range("A3").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
    Rows("3:3").Insert Shift:=xlDown    ' I think this is what you want. It will leave row three empty for pasting or recording.

 

[mikerickson]

If you copy N rows and Insert rather than Paste, Excel will shift the existing rows down to accommodate what has been copied.