I have two spreadsheets, laden with formulaes etc. They are roughly alike, use the same macros etc.
The first one is called MS-1 and MS-2. I want have one file, with MS-2 on the Sheet 2 of MS-1.
I tried a normal copy and paste routine, formulas, but it didn't work. It just produced a whole host of zeroes.
There doesn't seem to be an import function to put this file into Sheet 2.
It's rather strange that Excel wouldn't have something to do this? Surely many people would want to join up their work like this.
Does anyone know how I can do this?
The first one is called MS-1 and MS-2. I want have one file, with MS-2 on the Sheet 2 of MS-1.
I tried a normal copy and paste routine, formulas, but it didn't work. It just produced a whole host of zeroes.
There doesn't seem to be an import function to put this file into Sheet 2.
It's rather strange that Excel wouldn't have something to do this? Surely many people would want to join up their work like this.
Does anyone know how I can do this?
