Copy and Paste from one workbook to another workbook

2 Replies - 1862 Views - Last Post: 13 May 2009 - 12:22 AMRate Topic:

Copy and Paste a whole Row

Posted 11 May 2009 - 05:35 AM

Hi,

I am currently trying to speed up some code that I currently use. It works and does exactly what I want it to but it takes to long so I have been trying to quicken up one of the sections that is copying information from one Workbook to another.

Quick overview of what I am trying to do:-
I have one control workbook that contains the code. I click a button and this allows you to select the input file (contains anywhere from 2000-50000) records. The code then loops through all lines in the input file and outputs them to 1 of 4 Output files depending on what the record is. These records will then go to one of 2 tabs in the relative destination file.