Looking for a trick to print all my saved outputs in one way

**MastroLube** · 03-23-2017, 07:42 AM

Hello everyone, maybe someone can help me accomplish that..

I'm a civil engineer and i use a xls file in order to verify the shear reinforcement in a slab.
XLS FILE

In this file there is something that annoys me very much: when i have to print each case I've to select it, press load, press print.
(look at this video: http://youtu.be/FaoZNfavPuA )

There is a way to accomplish that in a faster way and less stressful ?

Thank you very much

Dennis

**Bernie Deitrick** · 03-23-2017, 02:10 PM

Yes - you can write a macro that will loop through all the values in your dropdown, re-calc the sheet, and print it out.

I was not able to open your file - my security settings would not allow it, but the general idea is this - for a sheet named "PrintOut" and a cell (D2) with a DV list:

Please Login or Register  to view this content.

Looking for a trick to print all my saved outputs in one way

LinkBack

Thread Tools

Rate This Thread

Display

Looking for a trick to print all my saved outputs in one way

Re: Looking for a trick to print all my saved outputs in one way

Thread Information

Users Browsing this Thread

Similar Threads

Print Page Setup Parameters Lost when Saved As

Excel 2007 : Excel saved print settings

Print path data saved in Excel

how to change # or copies to print in a saved sheet?

[SOLVED] Spreadsheet won't print changes I made, only what was prev. saved.

[SOLVED] Printing from a saved print file

excel 2003 changing saved print settings

Bookmarks

Bookmarks

Posting Permissions