Copy and paste data to a new sheet
 

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. For example the database column heading
will look like this:

Date Clinker Produced Clinker Consumed
Difference


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 it's approriate place unde
the column headings. I just need help getting started, I'm stil
learning this VBA stuff.

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

Copy and paste data to a new sheet
 

Hi

Try this
http://www.rondebruin.nl/copy1.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"bambam77 " wrote in 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. For example the database column headings
will look like this:

Date Clinker Produced Clinker Consumed
Difference


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 it's approriate place under
the column headings. I just need help getting started, I'm still
learning this VBA stuff.

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/

Copy and paste data to a new sheet
 

Thanks a lot


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