I apologize if my previous explanation wasn't clear. Let me rephrase the issue I'm encountering.
I'm working with a table within a workbook. My intention is to create a backup of this table by duplicating it. However, I've noticed a strange behavior: when I then modify the original table (for example, by deleting some rows), the duplicated table loses all its rows and becomes empty.
I need a way to back up a table before I perform any modifications to the original, such as deleting or adding rows. My goal is to have a complete, static snapshot of the table that remains unaffected by subsequent changes to the original.
Any guidance or suggestions would be greatly appreciated!
Thank you in advance for your help.