Hello,
the main idea behind this exercise is to generate reports based on user selected column headings with certain heading having criteria to it. unless there is any other more efficient way than this.
i got a worksheet...with 20 column headings. new column headings will be added if required so. i need the excel form to automatically generate all the column headings.
i was thinking of 2 listboxes. in listbox1 all column headings shud be listed when form is opened. the user double clicks on the column heading in listbox 1 which should go to listbox2. based on the fields listed in listbox2,the relevant data from the worksheet should be retrieved and put on a temp sheet.
the twist here is (for me)....some column heading contain date values. so when a date field is selected from listbox1, the user shud have the option of selecting a start date and end date. Based on the start and end dates of the date field selected, the code shud retreive those records alongwith the details from the other fields in the listbox2.
the user can select one or more date fields from listbox1 and each date field selected has its own start and end dates.
thanks...
Configuration: Windows XP Firefox 3.0.10
Add button to excel run macro Add color formatting in excel Automatically add row in excel form Converting ip address to binary form Ethernet controller driver Excel add-in rupees converter Excel viewer 2007 Formula to add a % increase as an excel formula How to add line to names in excel How to add row office excel 07 How to add the data from other worksheet in a column excel Macros for moving email addresses from one column to another in excel Ms excel vba form control combo box value Network controller driver Transfer microsoft outlook address book to excel file Vba excel chart add a series legend Volume control mixer device add hardware Windows xp add to network a domain controller for domain not connected