Hi,
I have a few dozen workbooks from each of which I’d like to copy the data in columns A to H of Sheet1 and paste it into a single worksheet. So, for example, the data from the first workbook would go into A1:H50 of the destination sheet, from the second workbook to A51:H100 etc.
Obviously I could copy the data in each of the worksheets and paste it all into a single worksheet, but I was hoping that someone could please suggest an easier (and less error-prone) solution?
Thanks very much!
Are you familiar with VBA? You can easily setup a macro to do all of this for you.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I'm afraid not.
Can this be easily done without a macro?
Thanks
Yeah, copy and paste.
AllFilesOpen&Import.xlsb
See the attached.
I have commented the code pretty well so you can see what I am doing, why I am doing it and what to do with it.
Let me know if you have any questions.
Last edited by mikeTRON; 08-12-2014 at 01:58 PM.
Thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks