Macro to extract data from other work book & add hyperlink

Hi

This I think this may be very tricky and not even sure it is possible, its way over my head.

I have 2 workbooks, one called “warehouse wastage” which sits in a folder on its own and in a sub directory I have one called “160712” this file will be in folder / JE / ALLOCATIONS

The 160712 is just the date the information was saved.

What I am trying to do it this, on the 160712 file I have a list of names in the U column, and these names will match the names on the warehouse wastage B6:F6.

On the warehouse wastage book N column I have a list of dates, if you look at N30 the date is 16/07/12 which is the same as the 160712 file apart from the / The dates in this column will be added when a file with the same date is added to the appropriate folder

If you look at E30 there is some data under the name Ross, this data comes from all the entries in the T column of the 160712 files that are against Ross’s name. The same will apply to the other names.

At the moment I have to open this file then add up all the entries under each persons name then add the data to the warehouse wastage file. Would it be possible for this to be done automatically with a macro when a file is dropped into / JE / ALLOCATIONS folder? I would prefer not to use a formula if I don’t need to.

One last thing if possible when the data is added I would like it to auto make a Hyperlink so when the data is clicked it will open up the date file.

I hope I have explained this clearly, and please feel free to tell me where to go if this is to much to do

Many Thanks

Hi Antonio

Thanks very mich for the help on this, i have tested the code and it is nearly there. The only thing that needs changed is on the Allocations tab in the "N" column the dates will already be there, i need it to look down the N column when it finds the date with no data then look for that date file in / JE / ALLOCATIONS then insert the data in that row, At the moment your code is adding the date to the N column. would it be possible to change this?