Hi,

I've need some help. I have a workbook with some data which is exported monthly from an application.
I also have another workbook which I use as a database of monthly data. I created graphs from this database workbook.

Now my problem is I need some method of scanning the 1st workbook and copying the numbers to the corresponding cell in the database workbook. The common value in both excel files is a ID no.
What I want is somehow to run a formula or macro which will take an ID no. and search the 1st workbook for the same ID. The 1st workbook may have the same ID in several different rows. The formula or macro should retrieve the sum value of that ID no. and paste it in the database workbook in a cell with that same ID no.

Can anyone help? I'm not sure how to begin.

I hope you can understand what I'm trying to do.