K
Ken Fickling
I have a similar need. I have 3 seperate workbooks I
want to combine. They all have 1 identical sheet "Index".
Each has about 10 other sheets which I want to
consolidate into 1 book, but they don't need to be
altered. The only hitch is that they all share a large
set of defined names. If I move or copy sheets, they get
screwed up. thx.
want to combine. They all have 1 identical sheet "Index".
Each has about 10 other sheets which I want to
consolidate into 1 book, but they don't need to be
altered. The only hitch is that they all share a large
set of defined names. If I move or copy sheets, they get
screwed up. thx.