Automatic Update for duplicate workbook

Hi,

I wasn't sure which section to post it in.

I have two workbooks, one for typing and doing work etc... and a duplicate workbook as back up.

I used the

Please Login or Register  to view this content.

to get the values out of the main workbook to the duplicate workbook.

But if I insert a new row or a new column, I need to go into the duplicate workbook and drag down or across the formula.

Is there another way about it to cut out my time and update it automatically?

Thanks

Hi,
I should of probably mentioned this:

The back up is created with the following additional formula:

Please Login or Register  to view this content.

From there, the back up data is stored in a file and I will find a macro that extracts all the sheet data from duplicate back up data into a text file to save in a specific folder.