Wanna try to copy and filter other csv files data

[Boris_Z]

Dear experts,

I tried to create a macro with index sheet and several sheets(a,b,c sheet etc.).

The index sheet described another csv file's postion and name(names T_data).

And I want to let this macro read the index and filter  T_data.csv first then copy the data and paste to a,b,c sheets.

But I met a problem here, when trying to run the function of copy and paste data to different sheets, it always unsuccessful to finish this step.

Hope experts could give me a hand to make it success.

Thanks all.

[#2]

Have you tried running your VBA step by step (F8 from the VBA window)? This usually helps me identify where / what the issue is.

[#3]

Hi, @Charla74

It shows fail to execute '53': could't find the data.

In this way, I want to ask experts for some references or informations about filter, copy, and paste from other excel in VBA or template.

[#4]

@Boris_Z 

Runtime error 53 indicates that the path and filename is not correct. So you'll have to check those very carefully - even the tiniest spelling error in the path or filename will cause this error.