I need a macro to pull from one spreadsheet "test" sheet monthly logged details and then take a template on another spreadsheet named: by group on sheet template -
On the "test" spreadsheet I need it to pull names A1 through A21 and by using the template on other spreadsheet - create tabs for these names and then on each sheet take the name and place it under the name field - which is C3:F3 - a merged cell.
I know the macro is probably fairly simple. I am just trying to get this done so that I do not have to create 300 or so templates from names. Any help would be greatly appreciated. You guys are the best!
On the "test" spreadsheet I need it to pull names A1 through A21 and by using the template on other spreadsheet - create tabs for these names and then on each sheet take the name and place it under the name field - which is C3:F3 - a merged cell.
I know the macro is probably fairly simple. I am just trying to get this done so that I do not have to create 300 or so templates from names. Any help would be greatly appreciated. You guys are the best!
