I need a macro that filter/s (entered via Input Box) several xls files before they can be combined to a single worksheet. Input Box will be used to filter the “Employee Name” in “Column C”. I should be able to enter one or more “Employee Name” to filter before consolidating. Also, the files are password protected. The macro must also have the password embedded (1234) so there’s no need to enter the password for every file.</SPAN>
The reason for this macro is each file that I’ll be consolidating contains more than 60,000 rows. I only need to copy around 50 rows only from each file.</SPAN>
The macro will ask which xls files to filter/combine.
The macro will automatically enter the password to each file. They have the same password "1234".
An Input Box must appear where I can enter the employee name I want to filter across all xls files I selected.
Can you anyone help me please?</SPAN>
The reason for this macro is each file that I’ll be consolidating contains more than 60,000 rows. I only need to copy around 50 rows only from each file.</SPAN>
The macro will ask which xls files to filter/combine.
The macro will automatically enter the password to each file. They have the same password "1234".
An Input Box must appear where I can enter the employee name I want to filter across all xls files I selected.
Can you anyone help me please?</SPAN>
Last edited:
