View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bambam77[_10_] bambam77[_10_] is offline
external usenet poster
 
Posts: 1
Default 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