PC Review


Reply
Thread Tools Rate Thread

Copying data to 2nd Workbook slows down as it proceeds

 
 
=?Utf-8?B?R3VzRXZhbnM=?=
Guest
Posts: n/a
 
      20th Nov 2006
I have a workbook with about 2400 rows and 70 columns of data. I then create
an empty workbook, add column headers for 10 columns. Using 5 columns of the
original workbook, I determine which rows contain data based on non-empty
cells. I then extract data from the row for the 10 columns and then place it
in the next available row in the output workbook. In the status bar I keep
track of the current row in the input workbook. The output workbook finally
contains about 3200 rows. I have Screen Updating = False. At first - up to
row 500 - it runs relatively fast and then just keeps slowing down until
about a tow per second???

The last time I propagated the output worksheet with 2900 rows and 10
columns of periods - just to try to force a size. It still did the same
thing. Any suggestions.

--
Gus Evans

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying Data from a workbook to another workbook Pam Microsoft Excel Programming 1 10th Mar 2010 08:51 PM
Copying data to another workbook Steve Microsoft Excel Programming 1 20th Feb 2009 10:49 AM
Copying data from one workbook to another Amber T Microsoft Excel New Users 1 19th Jun 2008 06:53 PM
Copying data from workbook/sheets to another workbook/sheet =?Utf-8?B?eXVrb25fcGhpbA==?= Microsoft Excel Programming 0 26th Jul 2006 07:33 PM
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 Microsoft Excel Programming 1 1st Apr 2006 08:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:50 AM.