Hi All,

I'm new to the more technical bits of Excel and I have tried to search around on the forums but have not found exactly what I needed. Maybe my search phrases were not complete enough… anyway, here's the problem I have.

I have 2 excel files.

1) Contains a table with supplier delivery data (date, supplier name, delivery quantity, PO number) from a number of suppliers - This is generated by someone else.
2) A monthly report which I do every month which covers defects, deliveries and returns.

Is there an automated way to maybe 'click a button' in my monthly report to just grab values off the supplier delivery data file, summing the deliveries by supplier and populating a table in my monthly report?

So far I've been manipulating the supplier delivery file by sorting the table by supplier and manually summing the deliveries and copy/pasting the values to the monthly report.

What jargon do you use to describe this process? Maybe I can search for it myself too.

Thanks.

Cheers,

Reach