Merging workbook with condition

[jmaocubo]

Hi!!!

Can anyone help me on this?

I've got a lot of wokbooks allocate in a intranet location (but i can use the explorer so see all of them) like: http://host.company.es/eng/workbooks/Forms/WebFldr.aspx

Is it possible with a VBA code to import the information in all workbooks to only one, like:

From all workbooks i just want the values in sheet2 - Cell A25 and C32
and i want that those values in the new workbook like : cell A25 goes to Cell A2 and C32 to B2.

This for the first workbook analised for the second workbook itīs the same cells but it's copy to A3 and B3.

I'm sorry about my English (it's very bad)

See attachement

Thanks in advance

[JBeaucaire]

Your PDF doesn't visually match you verbal description above. C32 or C25? This macro uses C32 as per your verbal instructions.

Please Login or Register  to view this content.

[jmaocubo]

Thanks JBeaucaire...

It's working more than fine