Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Hide group of a columns based on cel value
I have 12 month columns worsheet plus a accumulated Total column.
I need to automatically hide columns, once I entered number value in a cell without using Macro. Example: If I enter (5) in Cell A1, the worksheet will show only data of 5 months (Jan-May) hiding June to Dec, etc. depending on month number entered in cell A1. Enter Month No = 5 Jan Feb March April May Accumulated_Total 60 50 70 90 40 310 Thanks and will appreciate your help. Rechie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Hide collapsed group headers on print | Excel Discussion (Misc queries) | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
How do I hide the outline of a Forms Group Box? | Excel Discussion (Misc queries) | |||
Automatic Sorting of a group of columns. | Excel Worksheet Functions |