Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste data to a new sheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
1 Create a macro to Copy & paste certain data to another sheet | Excel Discussion (Misc queries) | |||
Copy data and paste to different sheet named on Group | Excel Discussion (Misc queries) | |||
Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
Copy and paste cahrt to new sheet-update data automatically? | Charts and Charting in Excel | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel |