Results 1 to 5 of 5

Hide Columns automatically based on year month(YYYY-mm)

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    bangalore
    MS-Off Ver
    2010
    Posts
    3

    Hide Columns automatically based on year month(YYYY-mm)

    Dear all,

    I'm new to this Macro programming. I was going through one of the report in which I have to first unhide Current and upcoimg month and then hide upcoming month. Example


    2014-08 2014-09 2014-10 Total
    ColA ColB Col C ColD ColE Col F ColG ColH Col I ColJ ColK ColL
    # of Tkts # of Tkts linked # of KBs # of Tkts # of Tkts linked # of KBs # of Tkts # of Tkts linked # of KBs # of Tkts # of Tkts linked # of KBs

    If I have to run a report for this week fortnight I unhide from Col D to Col L and input the data below D2,E2 and F2 and after completing the input of records hide Col G - Col L.

    Do I have to Insert three columns every month or just hide and unhide of the columns can resolve the porblem.

    Please help in resovling the query.
    Attached Files Attached Files
    Last edited by Jeevhoney; 09-11-2014 at 01:36 AM. Reason: uploaded the example file

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 06-13-2017, 09:49 AM
  2. Convert Month Day, Year to dd/mm/yyyy
    By Apple Ling in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-30-2013, 07:31 AM
  3. Replies: 2
    Last Post: 12-01-2012, 03:06 PM
  4. Hide Columns automatically based on date
    By chrisjc19 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-06-2011, 03:32 PM
  5. How do I automatically hide columns in a worksheet based on a cell value?
    By dkhedkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2005, 09:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1