keep it separate and have my macro pull in the data from sheet1 in woorkbook1 then apply it to the templates which will create new sheet in current workbook with all my
data filled in.( i am putting the templates( which are sheets in the workbook) in the current workbook and i have templates that are really sheets.))
Bookmarks