Pasting data and dates
 

I have a macro that currently runs data calculation at the end of th
day once a button is pressed. I want to add to this by taking this dat
and pasting it to a database in the order of its date. For example th
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 fro
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 shee
along with the info. The only thing in my data base now are the coulum
headings

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

Pasting data and dates
 

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/

.