EXPORT COMMENTS from the ALL sheets of the WORKBOOK to another sheet
Recently I've received a question: How to export all comments from all sheets in one workbook to another new sheet. You will create a VBA code, which will help you:
1.Create a new sheet
2.Name this sheet as "Comments"
3.Name 3 columns as
-"Comment In" - for address of the Comment -Name of the sheet & cell address
-""Comment by" - the author of the comment-"Comment" - the text.
4. Put all these headers in Bold and specific color.
5.Extract Comments.
Finally you will see a trick - what will happen if the name of the author will be changed in the comment.
My Links:
🔴Youtube: / myexcellife
🔴Pinterest: https://www.pinterest.es/jekasama/
🔴Twitter: / jeka_sama
🔴Instagram: / my_excel_life
Thank You for Visiting my Channel ❤️
#MyExcelLife #ExcelTutorials #exceltips #excel @MyExcelLife
Watch video EXPORT COMMENTS from the ALL sheets of the WORKBOOK to another sheet online without registration, duration hours minute second in high quality. This video was added by user My Excel Life 15 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,898 once and liked it 172 people.