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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Hide group of a columns based on cel value
You would need a macro to do that.
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Rechie" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Hide group of a columns based on cel value
You will need a macro as there is no standard function to hide/unhide
columns/rows. "Rechie" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Hide group of a columns based on cel value
Dave,
Thanks for the Information, appreciate it! Rechie "Dave F" wrote: You would need a macro to do that. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Rechie" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Hide group of a columns based on cel value
Thanks for the Information, appreciate it!
Rechie "Toppers" wrote: You will need a macro as there is no standard function to hide/unhide columns/rows. "Rechie" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic Hide group of a columns based on cel value
How would you write the macro to do that? I have a similar issue.
Thanks, Courtney "Dave F" wrote: You would need a macro to do that. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Rechie" wrote: 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 |
Reply |
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 |