| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unhide column if range of cells contain data
I have a workbook with 2 worksheets named Quote and Collection.
The Collection worksheet has column headings in cols D to BI Data entered in the Quote worksheet is transfered to the relevant cols in Collection worksheet by means of "IF" formulas ie. =IF(Quote!J8="Electrical",Quote!P8,0) I would like to hide any cols in Collection worksheet that contain no data, or even better to unhide those cols when they do contain data. Any help would be appreciated Malcolm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unhide column - why doesn't click unhide column work? | Excel Discussion (Misc queries) | |||
| How to unhide data in cells that have the text-wrap formatting app | Excel Discussion (Misc queries) | |||
| How do I sum a range of data (column) that has #num! in some cells | Excel Worksheet Functions | |||
| How do I unhide a column when format/column/unhide won't work | Excel Worksheet Functions | |||
| Unhide cells when data is entered | Excel Worksheet Functions | |||
Linear Mode
