I have a worksheet that has 4 columns and an unlimited number of rows. The first, second and third columns have redundent data in order for me to actually create a table with Parent Child relationships (that's why I have redundency in Columns A, B and C). I have a Macro that EE Professional I could put a filter on each Column, so I can collapse the data table to work only on a particular section of code at a time but I'm looking for a more "esthetic" way of presenting the selection. The current sheed has a way to auto add records and then auto sort using a Form (written by EE Professional Epaclm (Curt))
How would I write a complementary macro that can do the same thing a filter can do by presenting a Form or Text Box, selecting the section and then having it filter or collapse the appropriate section? I also have to have a macro to reexpand it back to display all.
Thank you in advance; sample attached.