Results 1 to 4 of 4

Need help to Make group col values till another value start with date col B:B value vba

Threaded View

breadwinner Need help to Make group col... 06-13-2014, 06:03 AM
ragulduy Re: Need help to Make group... 06-13-2014, 10:02 AM
watersev Re: Need help to Make group... 06-13-2014, 11:14 AM
breadwinner Re: Need help to Make group... 06-20-2014, 03:15 AM
  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Need help to Make group col values till another value start with date col B:B value vba

    Dear Experts



    I have set of 2 range WK & Date, Here i want make group of rows from one wk till another wk start Hide group value is date..

    WK-14 Y-13 is in column A2 towards B2:B8 1-Apr-13 Make group Under WK-14 Y-13 those dates in B:B col
    2-Apr-13
    3-Apr-13
    4-Apr-13
    5-Apr-13
    6-Apr-13
    7-Apr-13
    One more macro Hide/Unhide the group values to view dates rows

    Find the attachment You may get understand easily
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  2. Group Field- change start date for year
    By Last_Resort in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-26-2013, 11:11 AM
  3. Replies: 1
    Last Post: 04-23-2013, 01:14 PM
  4. Make date ranges for graph (choose start and finish date)
    By zeko90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2013, 09:13 AM
  5. Replies: 4
    Last Post: 10-14-2012, 12:25 PM

Tags for this Thread

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