You are reading a single comment by @Emyr and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Emyr
Inconveniently an Excel update has deleted my personal macro book so I can't find my previous example of when I did this.
I'm looking for a macro that opens each file in a folder, copies the contents of each worksheet and pastes them into a new workbook, one after the other. I basically just want to aggregate loads of workbooks/sheets into one.
I could rewrite it but I'm a bit rusty so wondering if anyone has one lying around.
I normally use the very useful RDB merge for this http://www.rondebruin.nl/win/addins/rdbmerge.htm but for some reason it doesn't like the sheets I'm working on. Can't work out why
Cheers