Hello,

I have a macro which selects a number of sheets and exports them into
a new file. One of the sheets is an admin sheet which contains
information for the other sheets (links). However, even though I
include this admin sheet in the selection for the new file, and it
places the admin sheet in the new file, all of the other sheets
reference the original file's admin sheet. Is there a way around this
instead of me adding code to the macro to setup the links within the
new spreadsheet?

kind regards,

Matt

Hello Matt,

This won't happen if you copy the sheets all at the same time
e.g. Sheets(Array("Sheet2", "Sheet1")).Copy
or ActiveWindow.SelectedSheets.Copy

DQ