Macro Help: When moving a row, it moves the row to the top rather than bottom

Thanks to arlu1201 for stating that I should open a new thread, sorry about that!

I am currently doing the exact same thing as the person is doing in the thread below and I am using her file and the code provided by arlu:

http://www.excelforum.com/excel-prog...ell-value.html

The only thing is, the code is moving the row to the bottom of the new sheet rather than to the top below the title cells. The original poster sorted this out but didn't explain how she done it. Can someone please explain to me what I would need to change to have the row move to the top of the new spreadsheet rather than to the top? If I need to import her file and paste the code that has been used then I will do.

Your post is unclear to me on which row you need the information to be inserted. I am assuming you want it after the title cells which could be row 2 and you want everything else shifted down. This is just a change of the previous posts code, i did not check to see if it works.

Please Login or Register  to view this content.

Many thanks for that stnkynts, that's great and a great start for what I want to do. There are two other things I need but if no one can help with these then doing this will be fine.

Is it possible to list the entries in chronological order by when they were copied to the spreadsheet? At the moment it is going:

3
2
1

Rather than:

1
2
3

But by the looks of things it does seem quite complex so not a big priority.

One last thing I would like to do is set this off automatically through a button, so I can accumulate a lot of orders as open, press a button and then the macro/code sorts it out. Is that possible?