Automatically copy an entire sheet from one .xls to another

[damian_r_Home]

Morning all.

I ideally need to take a specific sheet from a specific document and copy it's entire contents, formatting, filters etc into a new xls such that when i open the new xls it will get all the data once more from the original sheet.

I know that you could simply set the new xls to copy it over on a cell by cell basis (such as "='[original.xlsm]Sheet1'!G29" in cell G29 of the new sheet etc) but this doesn't copy over all the filters and formatting.

Is it even possible to do this?

Thanks in advance

D

 

[damian_r_Home]

^^ yes

 

[damian_r_Home]

^^ yes.

However I think i'm going to close this thread and start a new one as I want to look at approaching this a different way now..

Thanks to all who have helped