Ok...here goes....

I have created a workbook that has approximately 15 worksheets.
One of these worksheets is called "Summary" and users print these out
at the end of each month. On the "Summary" worksheet, I have 20
separate "forms" that auto update as data is entered into another
sheet. At the end of the month, not all of the individual summary
sheets have data in them. I only wish to print the summary sheets
(numbered 1 through to 20) that have data in them. The ONLY cells in
the summary sheets (all 20 of them) appear in Column G. (If no data is
entered column G will be completely blank, if data has been entered
into the other sheets, it will auto fill) I want to ONLY print the
summary sheets that contain data.

Does this make better sense???

Tar muchly
Sandi


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=514285