Hi experts,
I have a lot of data in one sheet (distributed on many lines, sometimes consecutive, sometimes not) covering each time 60 consecutive rows.
I need to copy them, apply a mathematical formula, and paste the value in a different sheet.
I am copying in a 2 dimensional table, processing, and pasting.
And it take ages...
What is the fastest way of passing lines of 60 rows of data in a table ?
Thanks in advance,
regards,
H.
I have a lot of data in one sheet (distributed on many lines, sometimes consecutive, sometimes not) covering each time 60 consecutive rows.
I need to copy them, apply a mathematical formula, and paste the value in a different sheet.
I am copying in a 2 dimensional table, processing, and pasting.
And it take ages...
What is the fastest way of passing lines of 60 rows of data in a table ?
Thanks in advance,
regards,
H.