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
Bookmarks