iNCREASING THE SPEED OF COPYING ROWS

[sreevignesh]

Hi how can i improve the speed of copying nearly 1000 rows from a sheet and pasting it triple the times on the another sheet... The destination sheet have nearly 90 columns each filled with formulas ,,.. Nearly it takes 1 hr fore complete process how can i minimize that.

 

[Special-K99]

So your're trying to paste a block of cells 100 rows by 90 columns from one sheet to three other sheets?
Do you really need the formulas? Couldn't you just Paste Values? That would speed it up.

Sounds like you need to redesign the spreadsheets.

 

[sreevignesh]

OK pls let me know how to paste a formula using vba. for ex consider this formula"=IFERROR(ROUND(IF(INDEX(Scope_List,R3C,RC90)="NA","",IF(RC[-39]="Planned",IF(RC[-29]>0,RC[-32]+VLOOKUP(RC40,Data!R6C25:R8C66,Data!R4C26,FALSE)," ")," ")),0),"")"