Hi - I am a novice with the code, I got help with the top half and don't fully understand it. Firstly I attach what the code does and the section in yellow is how I need the code to work. For one client who has several due dates for the 3 tasks in the macro - it reports only one line instead of all lines.
Secondly after "Return" marked by asterix's below - what can I put in the code to allow further formatting. Forgive the recorded macro bit at bottom - I will eventually tidy this up when I know it all works.
Test sample to test code.xls
Bookmarks