A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Programming
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Copy data from one workbook to another workbook at the next available row



 
 
Thread Tools Display Modes
  #1  
Old May 1st 12, 04:01 PM
dguest dguest is offline
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 1
Default Copy data from one workbook to another workbook at the next available row

Hi

I hope someone can help me as I have been trawling through the internet to find the correct coding. I've attached the files I'm using.

Basically the "Training.xls" data needs to be copied into the next available row in "TrainingHistoryData.xls" but I have had no luck trying to find the coding I need to get this to work properly. I'm going to have several workbooks to paste into the "TrainingHistoryData.xls" as each one refers to a different manager.

Can anyone provide me with a code for this. I am fairly new to coding and really want to learn but I have now spent hours trying to code just for this one simple task so any help would be appreciated.
Attached Files
File Type: zip PMG JTC Compliance.zip (95.0 KB, 9 views)
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to copy specific data from master workbook to another workbook Mark767 Excel Programming 12 September 1st 09 08:57 PM
Copy data from Workbook Alpha & reorganize it in Workbook Bravo u473 Excel Programming 1 October 31st 07 02:37 AM
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook. Cristobalitotom Excel Programming 0 July 6th 06 12:24 AM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook burl_rfc Excel Programming 1 April 1st 06 08:48 PM
Import/Copy some data from one workbook to a similar workbook [email protected] Excel Programming 11 March 7th 06 12:34 PM


All times are GMT +1. The time now is 02:51 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.