Good Day!
I have a template with 2 different macros which gets it's data from another input file.
1st Macro:
I need to first populate a list box based on the unique value of a certain column (AZ) of the input file. Once it's populated, the user then selects which among the list he/she wants (one or more values can be selected at once - minimum 1 value).
NOTE: either List Box (Form Control) or List Box (ActiveX Control) depending on what is applicable - no idea at all
2nd Macro:
Use the selected items to copy the rows from the input file then copy to the new file under a certain worksheet name.
-below is the code used to copy data, but needs editing to copy only those that are under the selected criteria from macro 1.
Attached files.
Thank you in advance.
Bookmarks