Hi guys and gals. Ive recently started to compile some really large workbooks which contain up to 210 worksheets in each workbook, which are populated by various people during the month for information. Traditionaly i print all 210 worksheets and then discard the one with no data captured in them. This is becoming a HUGE waste of paper and was wondering if there is a VBA macro that could filter through each worksheet from sheet2:sheet210, check to see which sheets have data in block $G$41 on every worksheet, then create one print file with all the sheets that do have data in $g4$1 and ignore the rest. Ive tried many times but im no vba wizard so i need you help please please please.