How to hide a row if there isn’t any data in a specified cell

This can be achieved with a simple VBA macro. If you supply a sample worksheet, then I am sure someone on the forum will supply you with a valid solution.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Try this:

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

That would depend upon the range. Would you care to elaborate with specifics as there are several approaches that could be taken depending on the ranges in question. There is no single simple answer.

This may seem very crude when compared to all of the cool VBA solutions, but seems like you can get what you want with a simple filter. Filter your TOTALS column. Once Filtered simply dis-select (uncheck) 0 and blank. Since only columns with 0 across the board will have a total of 0 should give you exactly what you want. Then to undo it simply recheck 0 or blank or both in the filter. Worked when I did it...

CAVEAT: When you hide blanks this will hide your section and subsection titles and is therefore ill advised.

Here is some code to hide:

Please Login or Register  to view this content.

and to unhide

Please Login or Register  to view this content.

Look here for how to add a button: http://office.microsoft.com/en-us/ex...010342137.aspx

See my link on thread 13

If you are not familiar with VBA very much, try to do it simple. Follow these steps......

1) Insert a shape like rectangle, circle, oval or whatever you like by clicking on Insert --> Shapes --> choose the desired shape
2) Hold down the left mouse button and drag on sheet at the location of your choice to insert the shape.
3) Right click on shape --> Edit Text --> To make the caption of your choice on the shape.
4) Right click on the shape again --> Assign Macro --> Select the macro from list of available macros.
5) click outside the shape and you are done.

Now when you hover over the shape, your mouse pointer becomes a link and when clicked, the assigned macro gets executed.

Hope that helps.

Replace this line of code

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.