Finding a value and then suppressing ALL rows WITHOUT the foundva
Yeah, what he said. :-)
--JP
On Jan 23, 5:40*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Tom
Select E:T and FormatHide.
DataFilterAutofilter on column U to filter out anything not '30'
FilePrint should get you only A:D and U with the '30' rows.
Gord Dibben *MS Excel MVP
|