A new Free Excel workbook has been uploaded to the Free Spreadsheets & Templates section of our website. This new workbook includes a series of macro’s that automate tedious and laborious Excel tasks. The macro’s have been developed by the XLAutomation consulting team in an effort to speed up our spreadsheet development.

We hope that you find these macro’s useful in your workbooks. The first macro to be included is…..
UnMerge & Duplicate

This macro will unmerge cells and duplicate the data from the merged cells into each cell in that merged cell. It is particularly useful when you receive a worksheet that includes many merged cells that you want to convert and use in a pivot report.