reza_doang
06-28-2010, 07:25 PM
Hi All,
i have a workbook that will share to anyone and i got macro from this group about tracking changes with comment.
Now, i have a workbook with many sheets and maybe have many changes with comment, so i thing i need macro that will create a new sheet and pull out all comments in new sheet.
i attach my sample, in that sample i have 2 sheet and comments.
after run macro, it will create a new sheet with sheet name "comments".
for more detail you can see the attachment.
many thanks for your help
reza
i have a workbook that will share to anyone and i got macro from this group about tracking changes with comment.
Now, i have a workbook with many sheets and maybe have many changes with comment, so i thing i need macro that will create a new sheet and pull out all comments in new sheet.
i attach my sample, in that sample i have 2 sheet and comments.
after run macro, it will create a new sheet with sheet name "comments".
for more detail you can see the attachment.
many thanks for your help
reza