Hello,
I have a problem that I hope you guys can help me with.
I will for simplicity make the problem a bit basic and then I hope I by myself can transform into the bigger picture :-)
I have two columns. Column A is the "maintask" and column B is subtasks. Usually a maintask have between 1-5 subtasks.
I have made the sheet so that maintasks in column A merges so it fits with the number of subtask, i.e. if I have 3 sub tasks in B1:B3 then the maintask title is merged to fit cells A1:A3.
This is all very nice, and I have no problem deleting subtasks IF they arent in the top cell, i.e. B1. The macro is so that it deletes the entire row, so when deleting B1's subtask, then entire maintask is also deleted since the title of merged cells is stored in top cell, i.e. A1.
How can I delete subtasks in the top cell without it deleting the title in the merged cells that contains the maintask title?
Please remember that I have simplified the problem :-)
Hope you guys can help!
Br
Fred
Bookmarks