hello there,

i have hit a "brick wall" in my head and i would really like it if someone could assist me in this.

what i am supposed to do is to link an excel file thru a macro and copy a sheet's information then filter it and display the information in a sheet in another workbook. i really do not know how i am supposed to do this and i would really like it if someone could lend me some assistance.

i have alreally created the macro userform which i will be using with the help of a command button to get the file and in my userform, there is a "generate" button which on click, the user will be able to see the results(filtered info from original file) in the workbook of the macro.


Please help.


thank you so much