View Full Version : Menu tree

02-01-2011, 10:57 PM

I would like to get assist writing a macro that explode a menu tree.

I have a menu tree file which contains menus, sub menus and menu's items (sheet "Source").
I would like to create a flat menu tree file. Each menu line will contain its own items and all the items related to its sub menus. (Sheet, "Requested Result ")
Please see the attached file