ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying data to 2nd Workbook slows down as it proceeds (https://www.excelbanter.com/excel-programming/377795-copying-data-2nd-workbook-slows-down-proceeds.html)

GusEvans

Copying data to 2nd Workbook slows down as it proceeds
 
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



All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com