| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding Rows when referencing a worksheet
Using VBA.
Formulas cannot hide rows or columns. They can only return results to the cell. Gord Dibben MS Excel MVP On Thu, 15 May 2008 11:45:05 -0700, Ray wrote: Hi, I am a new user and would appreciate some help with what is probably a simple problem. Using the formula below I am copying data from one worksheet to another based on if data exists in one of 3 cells. If there is no data in either of these cells I would prefer to hide the row instead. How can I do this? =IF(JobList!$K2<"",JobList!A2,IF(JobList!$L2<"" ,JobList!A2,IF(JobList!$M2<"",JobList!A2,""))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| How do I stop rows from hiding when sorting a worksheet? | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Hybrid Mode
