Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 13th 07, 01:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 57
Default 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   Report Post  
Old March 13th 07, 01:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2,574
Default 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   Report Post  
Old March 13th 07, 01:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default 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   Report Post  
Old March 13th 07, 03:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 57
Default 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   Report Post  
Old March 13th 07, 03:15 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 57
Default 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   Report Post  
Old July 16th 08, 08:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 22
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? Marc New Users to Excel 1 March 10th 06 06:10 PM
Hide collapsed group headers on print [email protected] Excel Discussion (Misc queries) 0 October 7th 05 08:02 AM
How do I automatically hide columns in a worksheet based on a cell value? dkhedkar Excel Worksheet Functions 1 March 5th 05 01:20 AM
How do I hide the outline of a Forms Group Box? MadTodd Excel Discussion (Misc queries) 7 January 17th 05 06:45 PM
Automatic Sorting of a group of columns. Josh Barbara Excel Worksheet Functions 1 November 15th 04 02:55 AM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017