Automatic Hide group of a columns based on cel value

R

Rechie

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
 
T

Toppers

You will need a macro as there is no standard function to hide/unhide
columns/rows.
 
C

Courtney

How would you write the macro to do that? I have a similar issue.

Thanks,
Courtney
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if formula 4
Find the position of a date 6
dates of month automation 3
Search 2 Criteria for 1 sep result 1
Conditional Averages with Multiple Columns 3
Find last day of month depending on criteria 12
Hide Columns Based On Date Value 1
How to determine the value? 2

Top