Getting information / running equations when importing multiple files.

[skyping]

Hi Experts,

Hope you can help.

I have a file which brings in data from another directory. This works well, BUT………
A) I would like to restrict the code to allow a maximum of 6 files to be imported.
B) The equations in J2:J5 are good, BUT I can’t get the equations to loop through any other files and put the associated details in the corresponding cells in column J. (e.g) J20:j23 for Run 2, J38-41 for Run 3…….until Run 6.

I have only written the equations for J2-J5 which are in the Main spreadsheets code module. The current code seems able to transfer the first files details, where I really need each files details.

I have attached 6 dummy files and the Main spreadsheet for you guys to have a look at…..

Please could you see if you can answer the above 2 questions for me?

Obviously, the code in the master workbook needs to be amended (ChDrive and ChDir paths (wherever you decide to put my dummy files) for any testing.

I would be really grateful if you can have a look and welcome your ideas.

Thanks for looking.

Skyping.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[skyping]

Thank you SO MUCH Bo_Ry!!!!

That is absolutely perfect.

SOLVED.