• 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.

easy way to paste a worksheet on multiple others

C

cold

New Member
Hi,

I would like to know if there is an easy and sure way to paste a worksheet on multiple others.

My original sheet is 80,000 rows x 32 columns and I would need to paste it on 280 others sheets within the same excel file.

I tried to group 280 sheets and paste them all at once but it failed. after 5-10 min. my computer froze and I had to force quit.

Thank you
 
Why are you trying to do that?? Sounds like unnecessary file bloating. If it was really necessary, I'd use a macro to go to each sheet 1 at a time and do the copying. Depending on what you are copying, (text, numbers, formulas, images, etc) would control how much time it takes.
 
Hi, cold!

In addition to what Luke M said I think that your memory got exhausted, and even you do it by a macro one sheet at a time... when you copy 280 times 80000 rows x 32 columns I'll bet it'd crash again, and if not, it won't be easy to handle in normal operation. Considered using Access?

Regards!
 
Thank you for your advices. I don't think access is a good choice for me since I'm using a lot of formulas (vlookups, match...). I will paste my original sheet one at the time over 10-15 sheets and split over many files.
 
Is there some particular reason for creating duplicate data? I just hate to see you do a bunch of work if there's an easier way to reach the ultimate goal.
 
You must log in or register to reply here.
Back
Top