+ Reply to Thread
Results 1 to 2 of 2

Automatically outline (group) rows based on date

  1. 11-13-2014, 05:39 PM #1
    jabba9
    jabba9 is offline
    Registered User
    Join Date
    10-19-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Automatically outline (group) rows based on date

    I have a standard worksheet with dates in Column A. Starting in row 2, column A has Jan 1, 2008 and continuing down to today. I'm trying to automatically group so that only the last day of each month is visible. Possible?

    Thanks
    Reply With QuoteRegister To Reply
  2. 11-14-2014, 05:33 AM #2
    venkat1926
    venkat1926 is offline
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Automatically outline (group) rows based on date

    suppose sample data is like this in column 1 of active sheet

    1/1/2014
    1/31/2014
    2/1/2014
    2/28/2014
    3/1/2014
    3/2/2014
    4/1/2014
    4/30/2014

    in my computer the configuration of date is m/d/yy

    try this macro "test"

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    I am not an expert. better solutions may be available
    [email protected]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Group WBS Rows Automatically Based on Indent Level (VBA)
    By rsfx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2024, 06:26 PM
  2. outline and group and subtotal excel data automatically
    By hasanpmp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2014, 09:49 AM
  3. insert group header -- above a group of rows -- based on consistent value within the group
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  4. Group row or rows with VBA based on date
    By missing string in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2013, 11:54 AM
  5. How to automatically delete rows in Excel based in day of week and date?
    By pr0no in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2012, 03:22 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1