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?

Please attach a sample sheet.

See attached to let me know how to create vba to move package count data from the second report to the pkg inventory column of the first report.
The issue is that sometimes the warehouse location may not be listed on the first report so I won't need the package count from the second report entered for that warehouse.

Attached Files

Book1.xls (28.0 KB, 8 views)

Are the warehouse names not going to be identical like here? If they were, you could do a simple sumif, no vba required.

No. The names will always be like they are on the example. Coming from two different reports, they are not formatted the same.

Is there something else that can be used as a key identifier, like WarehouseID, that would be common to both reports? Can you redesign one report or the other so they have compatible data? If not, then I really can't see how it could be done.

OK. I have created some additional text to change the names on the first report to match the warehouse names on the second report. What's next? Remember that some of the warehouse names may not show up each time on the first report at the top.

=sumif(b14:b18,a3,c14:c18)

Great.
Thanks much.

Think nothing of it. :-)