Your code just needs to insert a row before you write to it.

Rows("1:1").Insert xlDown

I'd consider moving this to Access where the order of records doesn't
matter. You query the database and use an ORDER BY clause to determine how
the records are sorted.


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Joe Bailey" wrote:
| OK, what I mean by a push-down stack:
| Consider a list
| DATE AccountAlpha AccountBeta etc.....
| 03-Sep-06 14,262.00 5,447.00
| 02-Sep-06 11,197.00 5,317.00
| 01-Sep-06 12,117.00 5,326.00
|
| Today is the04-Sep-06, and todays account values need to be inserted at
the
| top of the list. Step 1 - push down stack; Step 2 Insert toays data
| DATE AccountAlpha AccountBeta etc.....
| vvvvvvvvv push-down stack vvvvvvv<<<< insert 04-Sep-06, 13767, 5842
| 03-Sep-06 14,262.00 5,447.00
| 02-Sep-06 11,197.00 5,317.00
| 01-Sep-06 12,117.00 5,326.00
|
| With the resulting updated stack now shows
| DATE AccountAlpha AccountBeta etc.....
| 04-Sep-06 13,767.00 5,842.00
| 03-Sep-06 14,262.00 5,447.00
| 02-Sep-06 11,197.00 5,317.00
| 01-Sep-06 12,117.00 5,326.00