Hi,
I'm trying to create a lookup table depending on the list on column A that the user requested then once button is clicked, it will automatically populate the tables. Now, I'm thinking of just using a formula to put in a cell for the lookup.
My problem is, how can I create the column header depending on the checked checkboxes from the userform. What should happen is: User will put the lookup items on column A then when button is clicked from the workbook, a Userform will popup containing all the header names with adjacent checkbox to each. Once Ok button is pressed, the worksheet will populate the column headers depending on the checked checkboxes.
Your help is much appreciated. Thank you in advance.
I'm trying to create a lookup table depending on the list on column A that the user requested then once button is clicked, it will automatically populate the tables. Now, I'm thinking of just using a formula to put in a cell for the lookup.
My problem is, how can I create the column header depending on the checked checkboxes from the userform. What should happen is: User will put the lookup items on column A then when button is clicked from the workbook, a Userform will popup containing all the header names with adjacent checkbox to each. Once Ok button is pressed, the worksheet will populate the column headers depending on the checked checkboxes.
Your help is much appreciated. Thank you in advance.