| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three tables on one worksheet, need to hide rows
Despite my limitation with writing codes, I need to find a simple to follow
code to hide rows without information in a specific column in three tables that I have on a single spreadsheet. The information on all these tables comes from another spreadsheet within the workbook hence upon changed to it, the information in my tables also changes. The table ranges are A67:I139, A171:I243 and A275-I347 They have the same number of rows but varying number of columns due to some merged columns. I want to hide rows that are blank in column 2 (in other words, display rows that are non-blank in column 2 in all the tables. Is this something that I can do with a code. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) | |||
| What is fastest for this? The Small VBA or many Worksheet Functions...? | Excel Worksheet Functions | |||
| Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
| how to hide rows in a protected sheet | Excel Worksheet Functions | |||
Threaded Mode
