d4y88
09-25-2012, 07:36 AM
Hi, I'm hoping somebody can help solve my problem.
I have a workbook with multiple sheets, i have a sheet "template" with a set format on that I would like to copy and paste into several other sheets. These sheets all have the word "AOB" at the end of their name, this macro is to be used by several users on different computers so I would like to avoid saving a template as an .xlt as this would cause problems on other machines.
Is there a way to loop through all sheets that contain "AOB" in their name and paste the template over the top?
Thanks in advance.
I have a workbook with multiple sheets, i have a sheet "template" with a set format on that I would like to copy and paste into several other sheets. These sheets all have the word "AOB" at the end of their name, this macro is to be used by several users on different computers so I would like to avoid saving a template as an .xlt as this would cause problems on other machines.
Is there a way to loop through all sheets that contain "AOB" in their name and paste the template over the top?
Thanks in advance.