Hi All,

This is just driving me CRAZY!!!

I have a worksheet which I have 20 forms created on that are
automatically filled out via another data entry worksheet. I have
edited them so that they have page breaks. So basically if anyone hits
the print button, all 20 pages print out...ughhhh

What I want to do is ONLY print the pages that have data entered into
them. I have found several posts about this but when I try them I get
error messages by the dozen....

Please can you help me, as I am about to create a new worksheet that
may have up to 400 pages on them and I only want to print the ones with
data entered in THOSE......

The work sheet is called Summary
The cells that ALWAYS contain the data I need are in column G

Thank you in advance
Sandi


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

Here is how I would approach the "problem"...

You have a data sheet (something in column "G") with values that get
posted to a specific cell on the "form sheet(s)"

Create a new sheet tab (I generally use "control" as the sheet tab
name) that lists all the newly created "forms" (~400) for example - in
the first column...

When deciding if the sheet should be printed, check the value in the
printing sheet (form, range = A14) against that in column "G"...

for i = 1 to endrow
for k=FirstForm to Lastform
SheetTabName=worksheets("Control").cells(k,1)
if worksheets(SheetTabName).range("A14")=worksheets(" Data").cells(i,7)
then
worksheets(SheetTabName).printout
else endif
next k
next i


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514285

Hmm..problem now is I didn't understand a thing you just told
me....lmao...I'm so sorry....

can you please put it into basic english for a VERY simple
simpleton???

I tried copying and pasting (changing the sheet names in "")...but now
it wants a name for the macro...

Thanks (especially for any patience you may have left!!!)

Sandi


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

please describe the sheets (forms sheets) and data (e.g., column "G")
more?


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514285

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

Not really...

Can you zip and attach the file to this post so I can figure out what
this looks like?

If the data is "private" please strip out what is not meant to be seen
by others.


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514285

Hmm....the file is industry specific and pretty confidential.....
Not sure if I can send it over a web page.....

Sandi


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

One suggestion may be to move the 20 individual pages on the summary
sheet to individual worksheet tabs...

See if that gets you anywhere.


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514285

Sorry to have wasted your time...:(

I can't put them on individual tabs as that would confuse the users too
much. Most of them are literally computer illiterate. They are flat out
remembering to put a date in places in the correct
format...sheeesh....

Spreadsheets I can create, but this is getting beyond me.......ughhhh

Sandi


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

I am sure you will get there (eventually)...

and just remember,
A Set-Piece battle plan never survives contact with the enemy…
Just as the best system ever devised will eventually have to face the
Users!


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514285