• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Paste as values long processing time

R

Rush

New Member
Hi all,

I currently have to produce a report which includes huge volume of data. So, I have to copy about 800,000 rows in 4 columns from one workbook to another workbook, which is fine as copying and pasting literally takes seconds.

Now, on the copied worksheet column before the pasted 4 columns contains a formula which merges code from the next 4 pasted columns into 1 column. So, now I have 1 column with 800,000 rows and all the rows contains formula(which merges data from next 4 columns).
I have to now copy and paste, that 1 column of 800,000 rows with formula, as values into another column as there is look up formula in the same sheet which looks up those codes from another set of data.

Copying and pasting that 1 column with 800,000 rows as values takes a awful lot of processing time. Is there anyway I can reduce this processing time? Is there anyway I can do the same work in smart and efficient manner?

Any help/suggestion will be highly appreciated.

Thank you

Rushank
 
Sir,

Can you please suggest where can we get that CALCULATION which can be turned off. I have tried excel option but under CALCULATION there are so many options.
 
Hi all,

Thanks very much for you invaluable help. As a result of this advise I'm able to complete my report in 30 instead of 1 hrs and 30 min, which is great as I can complete more work in same time. Thanks Hui!!:-)
 
You must log in or register to reply here.
Back
Top