Hello again. I would like to copy any comments from a source worksheet to a report worksheet if they occur. The user chooses a row from a listbox and then a report worksheet is generated based on what is selected. The report page is similar to the format below

Assignment Points Comment

Test 1 9
Test 2 Absen
Test 3 85
Test 4 Absen

I've tried sooo many things but can't seem to get to the comment part to work. Any advice would be appreciated
Thanks again

Robbyn