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
Смотрите видео EXPORT COMMENTS from the ALL sheets of the WORKBOOK to another sheet онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь My Excel Life 15 Ноябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,898 раз и оно понравилось 172 людям.