Copy/Insert rows
Hello,
I am copying rows and inserting them further down the sheet. Trouble is, I
can only select and copy 10 rows before Excel claims it's out of "resources".
That's a bit annoying since I need to copy 200 rows - repeatedly.
Is there a way to free up "resources" so that I could, copy, say, 20 rows at
a time?
Or are there better methods altogether? I am essentially replicating data,
although every 200 row chunk is slightly different; find/replace takes care
of that.
Thank you.
|