Hi I have attached a sample workbook.
I would like to create a Macros which can take the existing worksheet and split it up into worksheets for each merged cell entry in column A. Basically you can see that the first entry, runs from row 1 to row 44, I would like to cut all those and paste that to a new worksheet and name it after the entry which in this case is "land erfeim", and do this for all subsequent merged cells.. reason being is i have more data in the subsequent columns for each unique row.
Bookmarks