I would like to know is there a way to unmerge all cell in a workbook from another workbook? I have a report that comes from another database and when exported from the database to Excel some of the cells are merged. I then link the data from the database Excel worksheet to a worksheet containing formulas. By having the cells unmerge the linking process becomes easier.
Thank you for any help you can provide.