VBA runtime Error. for copying cells from multiple workbooks to one master workbook.

Hello ALl,


Can anyone help me figure out why this VBA is not working properly?

Thanks for any help or suggestions.

Mike Rand


create file folder on the desktop called Master Estimate. put the DATA STORAGE and Job1 into that file

VBA looks for that file then opens the file Job1 and copies the appropriate cell information from the source cells to the destination cells.
then it looks for Job2 then Job3 etc until it opens and copies all source cells as required it closes them.


thanks

Cross-posted here:

https://www.mrexcel.com/forum/excel-...orkbook-2.html

Try this macro:

Please Login or Register  to view this content.

Make sure that every job in column A has a corresponding file saved in you desktop folder.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Please also take a moment to read through our very simple rules before posting again (link in my signature line). Thanks.

You are very welcome.