| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for hiding rows
I am trying to take a mail list that is in Excel and create a macro to only
show every 10th row. I need these addresses for a survey, so it doesn't make any difference wheather there is information in all the columns of the worksheet or not. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for hiding rows
Add a column that contains the number sequence 1 through 10, repeating, down
the sheet as far as there is data. Apply an AutoFilter(DataFilterAutoFilter) to your column header. In the drop down in the header of your new column, select any number between 1 and 10. Visible result: every 10th row. HTH, -- George Nicholson Remove 'Junk' from return address. "Linda" wrote in message ... I am trying to take a mail list that is in Excel and create a macro to only show every 10th row. I need these addresses for a survey, so it doesn't make any difference wheather there is information in all the columns of the worksheet or not. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for hiding rows
Thank you. That was exactly what I was hoping for.
Linda "George Nicholson" wrote: Add a column that contains the number sequence 1 through 10, repeating, down the sheet as far as there is data. Apply an AutoFilter(DataFilterAutoFilter) to your column header. In the drop down in the header of your new column, select any number between 1 and 10. Visible result: every 10th row. HTH, -- George Nicholson Remove 'Junk' from return address. "Linda" wrote in message ... I am trying to take a mail list that is in Excel and create a macro to only show every 10th row. I need these addresses for a survey, so it doesn't make any difference wheather there is information in all the columns of the worksheet or not. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Can I develop a macro to add blank rows to a list in Excel? | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| inset rows and copy formatting , excel macro | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Hybrid Mode
