Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Merging excel sheets

Options
  • 30-11-2014 5:14pm
    #1
    wb
    Registered Users Posts: 1,752 ✭✭✭


    Hi folks,

    Anyone know if there's a simple way to merge multiple (about 50) excel files into one?

    I've tried everything! I'm reasonably handy on excel although I'm haven't really used marcos before.

    Any ideas? I don't want to have to open them all and copy and paste.


Comments

  • Options
    #2
    CountyHurler
    Closed Accounts Posts: 8,657 ✭✭✭CountyHurler


    Without further information on what the rows/columns contain, it's difficult to give an opinion.

    My only advice would be to first back up every document before you touch them... And then perhaps looking at first reducing the number of individual Excel documents by merging the worksheets from multiple documents in to just one Excel document.


  • Options
    #3
    Dravokivich
    Moderators, Category Moderators, Music Moderators, Politics Moderators, Society & Culture Moderators Posts: 22,360 CMod ✭✭✭✭Dravokivich


    wb wrote: »
    Any ideas? I don't want to have to open them all and copy and paste.

    A macro can do that, but but you may need to look through them all to confirm the sheets/tabs within each excel file will all have unique names, so that there'll be no clash when you combine them.

    I used to run a script that did something similar a few years ago, will see if I can dig it up when in work tomorrow.


Advertisement