| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Rows using a returtn value in a column
Hi,
I have the following data: 0 0 FORNECIM. SERVIÇOS EXTERNOS 0 0 CONDOMÍNIO 0 0 ELECTRICIDADE, ÁGUA E GÁS 62214001 T GÁS 62213001 T ÁGUA I would like to create a macro that will hide the rows when column 2 as the value "0" Can someone help me ? Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Rows using a returtn value in a column
How about using an AutoFilter??? Data - Filter - AutoFilter -
-- HTH... Jim Thomlinson "Carpe Diem" wrote: Hi, I have the following data: 0 0 FORNECIM. SERVIÇOS EXTERNOS 0 0 CONDOMÃNIO 0 0 ELECTRICIDADE, ÃGUA E GÃS 62214001 T GÃS 62213001 T ÃGUA I would like to create a macro that will hide the rows when column 2 as the value "0" Can someone help me ? Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Rows using a returtn value in a column
I have a lot of sums in the table, if I use total its dificult to
control. So I need to use VBA Jim Thomlinson wrote: How about using an AutoFilter??? Data - Filter - AutoFilter - -- HTH... Jim Thomlinson "Carpe Diem" wrote: Hi, I have the following data: 0 0 FORNECIM. SERVIÇOS EXTERNOS 0 0 CONDOMÍNIO 0 0 ELECTRICIDADE, ÁGUA E GÁS 62214001 T GÁS 62213001 T ÁGUA I would like to create a macro that will hide the rows when column 2 as the value "0" Can someone help me ? Thank you |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide Rows using a returtn value in a column
I have a lot of sums in the table, if I use total its dificult to
control. So I need to use VBA Jim Thomlinson wrote: How about using an AutoFilter??? Data - Filter - AutoFilter - -- HTH... Jim Thomlinson "Carpe Diem" wrote: Hi, I have the following data: 0 0 FORNECIM. SERVIÇOS EXTERNOS 0 0 CONDOMÍNIO 0 0 ELECTRICIDADE, ÁGUA E GÁS 62214001 T GÁS 62213001 T ÁGUA I would like to create a macro that will hide the rows when column 2 as the value "0" Can someone help me ? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How we can hide the rows no. 1,2,3,4,.. &Column no. A,B,C,D...AA | Excel Worksheet Functions | |||
| Hide unbolded rows in specific column | Excel Programming | |||
| Macro to Hide rows based on value of column F | Excel Discussion (Misc queries) | |||
| hide column and rows | Excel Discussion (Misc queries) | |||
| chk box to filter or hide rows based on value in a column | Excel Programming | |||
Hybrid Mode
