Is it possible to link a range of cells to another spreadsheet so that the formatting and comments are linked too.....as it does with copy & paste?
I have been told this is only possible with VBA/macro. I have linked a sheet from one workbook to another and need see the comments and formats. I have no experience with VBA code. I am linking an entire worksheet.