Unhide column if range of cells contain data

W

wizardmalcolm

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function returning SUM of 2 adjacent cols in 2 separate cells 7
Formula For Counting Records 5
Repeat the macro using different ranges 1
Hide columns based on row values 2
Hide unused rows based on column info 5
Find Matching Data Two Columns 1
Copy Row if Column A matches between different worksheets 1
Sumproduct across multiple worksheets 3

Top