I run two reports showing package counts at various warehouses. I need to be able to take the total number of packages from one report and copy it to the other report but the locations may not always be the same from one report to the other. How can I create a vba to look for data in a warehouse from one report and find that warehouse in the second report and then place that quantity in the second report?