Forum Discussion
AandNSeaver
Apr 29, 2022Copper Contributor
"Paste: Link" does not work in tables
Is there some way to enable the use of "paste link" inside tables? I am creating a workbook to track contracts and invoices for multiple projects. The first tab is a master list of all the items ...
- May 01, 2022
As you have found, Paste Link is not compatible with tables, so if you want to use the advantages of Paste Link, you'll have to convert your table to an ordinary range.
Alternatively, you could create a macro that formats selected cells the way you want. If you assign the macro to a Quick Access Toolbar button and/or a custom keyboard shortcut, you can easily run it.
BathindaHelper
Copper Contributor
AandNSeaver Can you pls share the macro.
AandNSeaver
Mar 15, 2024Copper Contributor
BathindaHelper
Sorry, I do not have the macro any more. Shortly after creating a macro I found there were some flaws in it and I didn't have the drive to sort them out. This tracking sheet was not critical to my work and it was taking more time than I wanted to get it working so I abandoned it. Sorry I can't be of more help.
Sorry, I do not have the macro any more. Shortly after creating a macro I found there were some flaws in it and I didn't have the drive to sort them out. This tracking sheet was not critical to my work and it was taking more time than I wanted to get it working so I abandoned it. Sorry I can't be of more help.