Can you sort the list first? If so you can then just have
you macro read it line by line and paste it to the
database, or (depending on the database you use) you could
export the resulting list as a table and append it to your
database table.

If you can't sort the original list, you could copy it to
another worksheet (hidden if necessary) and sort it there,
then copy it to the database.

-----Original Message-----
I have a macro that currently runs data calculation at
the end of the
day once a button is pressed. I want to add to this by
taking this data
and pasting it to a database in the order of its date.
For example the
database will look like this:

Date Clinker Produced Clinker Consumed
Difference
8/3/2004 5000 3000 2000
8/4/2004 7000 3000 4000



The problem is how do I get the macro to take the date
and info from
the one sheet, and paste it on the other in order of the
date.
Note that the date is not in the database, it's on the
other sheet
along with the info. The only thing in my data base now
are the coulumn
headings.


---
Message posted from http://www.ExcelForum.com/

.