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