Can a template be created and stored in a vb module within another workbook
or does the vb code of the other workbook have to point to it to use it? I
have a lot of data that I am trying to copy to a formatted sheet with merged
cells, however when the search for data code fires it ends up with more rows
then can be stored on one formatted sheet, so I would like to be able to
create some type of code to count how many rows of data the search finds and
then copy the template to the working workbook, rename the new sheet. So if
the template has only say 13 rows of usable space for data storage and the
search finds 23 rows of data, I would like the code to create a new sheet
from the template and then create how many ever pages it needs to store the
data based off the first page of the template.(Only the first 17 rows of the
template are formatted, so they could be programmaticlly copied and pasted
into the same sheet).