[stuckinNH]

I found a great file on the web, (fully legal to download & so appreciated) - 1 workbook, has Data sht (very simple short list) has Form sht with print module/macro in it referencing indirect data pull from Data sht to populate Form sheet. It works great EXCEPT - it only has options to Print Preview and Print out. I need to somehow save each newly "merged" sheet (i.e. one form for each record in the Data file) saved as a New Spreadsheet named from cell G78 which is in the range on the Form sht. I have worked on this for days and just can't get it to work right.... Ideally, I would like to almost Print Preview the "merged" form, and save each "previewed" sheet as it's own workbook named as shown in the example file. I have it working enought that after the ActiveSheet.PrintPreview it will save the Workbook to a new file, but I don't want the whole workbook, just the active sheet range B7:BH to B79:H79. Probably very simple for anyone but me.. Currently I have to manually type every single order for each record in the Data table ! I so appreciate any help - even if it's just point me in the right direction. Thank you so much