I have an Excel workbook open called 'SoureWorkBook'. There is a sheet in this workbook called 'FormulaSheet', and 'FormulaSheet' is full of formulas solely referencing a sheet called 'DataSheet'. I need this sheet to be systematically inserted into several other workbooks.
If I have 'SourceWorkBook' opened, is there a VBA code that can be execute to insert this sheet automatically into all of the other ones?
Assume the current location of the current workbook is : C:\My Documents\Folder1\
Assume the current file is called 'SourceWorkBook.xlsm'
Assume the current location of the other workbooks is : C:\My Documents\Folder2\
Assume the target files that need the sheet inserted all start with 'TargetWorkBook - ' and the extensions are 'xlsx'.
Any takers? Any more info needed from me?