1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel merged spreasheet -save as and print HELP

Discussion in 'Business Applications' started by stuckinNH, Sep 9, 2008.

Thread Status:
Not open for further replies.
  1. stuckinNH

    stuckinNH Thread Starter

    Sep 9, 2008
    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 :)

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/748570