stackoverflow.com/questions/2631239/is-there-a-way-to-hide-a...

I know of several approaches using a macro (VBA) to show/hide columns and rows in Excel, but I cannot figure out or find a way to do this using either a formula or conditional formatting. Of particular interest is Excel 2007 - but I'd be curious to kno ...

www.mrexcel.com/forum/excel-questions/550371-hide-rows-based...

I dont know much about VBA but can anyone help? I need a macro that will hide all rows where the formula result is zero as a result of the cost centre selected from a validation list?

answers.microsoft.com/en-us/office/forum/office_2010-excel/a...

I have to develop an excelsheet where a row is hidden automatically if the value in cell e is 1 and unhide the row automatically if the value in cell e is 2. And this has to work for all rows.

excel.tips.net/T001940_Hiding_Rows_Based_on_a_Cell_Value.htm...

This tip contains a macro to hide rows that contain data you don't want to see. (Tips.Net)

social.technet.microsoft.com/Forums/office/en-US/ee76d08d-33...

A useful thread but my favourite solution is:

1. Find excel.exe
2. Create shortcut to excel.exe on desktop
3. Drag and drop excel files on shortcut
4. Voila, multiple instance of excel.exe and all file remain visible...
   Category:Open workbooks in different windows
   Visited132

stackoverflow.com/questions/6709225/merging-data-in-open-lib...

I have two sets of data in csv format which share a field called "sku".

The second one has additional columns which need to be added to the first, but they have different sets of data, only some of which overlaps.

The only data which ne ...