I want to do a few things in my add-in that I have no idea how to do:
1) I want to do a custom sort. This would be the sort order: 1, 6, 3, 10, 15, 21, 7, 5, 9, 11, 22, 23. I know this is possible in Excel 2007 but I was wondering if I can do it with VBA in 2003?
2) I created a form that will give my users a couple of thousand ways of viewing their data. The form itself I have complete the way I want it to work. However, the code to run the report seems to long the only way I can think to do it. Here is a the form with the form code. What I want it to do is create it so the user can choose what they want in the first column of the pivottable and then the 2 and so on (up to a maximum of 6 columns) and then choose the date grouping and if they want any other information in in the data columns and finally they get to choose the data they want to view. However the only way I can think about doing the code is nesting about 10 if's deep and not only would this slow things down but it would take roughly 500 lines of code minimum to work. Is there any other way of doing this? If you need any more information, don't hesitate to ask.