Good day. Need help.
I have an Excel table1 in workbook1 contains list of servers by department. Some of the cells (the servers) in the table1 have comments added by “Add Comments” option.
I have another Excel table2 in workbook2 contains the servers (the master list).
I want to transfer(copy) the comments on the cell of table1 to table2 if the server matches using power automate. Meaning that the AuthorName, CreationDate, Content will be copied over to the table2 and appear as Comment as well. Could this be done?