There's no such thing as a stupid question, but they're the easiest to answer.


Search Search
Search for:
Tech Support Guy > > >

Excel merged spreasheet -save as and print HELP


stuckinNH's Avatar
stuckinNH stuckinNH is offline
Computer Specs
Junior Member with 1 posts.
Join Date: Sep 2008
Experience: Intermediate
09-Sep-2008, 09:50 PM #1
Unhappy Excel merged spreasheet -save as and print HELP
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
File Type: xls SAMPLE MASTER RETROFIT Sales_Order.xls (101.5 KB, 218 views)
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

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.

excel, excel macro, excel macro copy paste, excel printing

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑