Combine data of some cells in multiple excel files into one sheet

[ricdamiani]

Hi guys,

I have hundreds of sheets with the same layout and I need to extract data from those sheets into 1 sheet.

There is a very similar topic I found some days ago in this forum, but my case is a bit different, as I need to extract the info only from some cells. The topic is below and Alf solved the problem:
http://www.excelforum.com/excel-prog...worksheet.html

The sheets are all into the following folder: C:\Users\5 - PRODUCTION\RUN SHEETS\
The cells it needs the extract the information are: C3, C5, C8, D8, E8, D9, G13, H13, F22, F24, F26, F29, F31, F34, F40, D43, E43, F46, D49, E49, F52, F55, C58, C59, C60, C61, C62

There is a macro that can extract the info from these cells into a single sheet?
This can save me some months of manually typing all this info :/

You can find below 1 of those hundreds (maybe thousands) sheets I need to extract the info:
2308.E5.xls

Really hope you guys can help me on that!
Thank you!

[Naveed Raza]

Hi ricdamiani

In which way want the combine data means rows wise or column wise.

[lotuxel]

Pls try attached which modified from your file!

[ricdamiani]

Hi ricdamiani

In which way want the combine data means rows wise or column wise.

Hi Naveed Raza,
Thank you for your reply.

The idea is every single excel file is a row, and the cells I mentioned are the columns.
Do you think it is possible?

Thanks for that.

Pls try attached which modified from your file!

Hi lotuxel,
Thank for your reply as well.

I had a look in the file and I didn't understand your macro.
Actually the goal is to get all the data from the mentioned cells from hundreds of excel files and combine them into 1 sheet.
The files would be the rows and the cells I mentioned would be the columns.
The sheets are all into C:\Users\5 - PRODUCTION\RUN SHEETS\

Is it something similar you did in your macro?

I thank you in advance.

[Naveed Raza]

for better understanding please provide one 3,4 workbook combine sample workbook.

[ricdamiani]

Hi Naveed Raza,
Thank you for your reply.

Please find attachments below:
0102.E1.xls
1282.E2.xls
2007.E2.xls
2310.E3.xls
Goal.xlsx

The goal sheet show the sheet I am looking for, with this structure, that compile all the other sheets into this one. The letters+number inside the cells are the cell number I need to extract from the other sheets.
The other sheets I attached, are examples of some of the sheets that I need to extract the information. You can see that the red cells are the cells I want to extract the information.

Do you think it is possible?

I thank you in advance.

[ricdamiani]

Hi guys,

Anybody else can help with that?!

Cheers!

[lotuxel]

Hi rocdamiani,
Pls see below and you have to put all the files to one file's sheets and Goal sheet is target sheet.

Please Login or Register  to view this content.

[ricdamiani]

Hi rocdamiani,
Pls see below and you have to put all the files to one file's sheets and Goal sheet is target sheet.

Please Login or Register  to view this content.

Hi lotuxel,
Thank you for your reply.

Sorry but I didn't understand very well.
I thought the macro was going to open each excel file in the folder and copy those cells into the goal sheet.
Is that happening in the macro? Or how it works? I couldn't understand very well your explanation before the code

Looking forward to hear from you

[ricdamiani]

Hi guys,

Anyone able to help me on that now?

Cheers!

[Ariff_Chowdhury]

Hi ricdamiani,
please find attached,let us know if this serves your purpose or not!

Goal.xlsm

Thanks

[lotuxel]

Hi lotuxel,
Thank you for your reply.

Sorry but I didn't understand very well.
I thought the macro was going to open each excel file in the folder and copy those cells into the goal sheet.
Is that happening in the macro? Or how it works? I couldn't understand very well your explanation before the code

Looking forward to hear from you

Yes!, I try to add the purposes :

Please Login or Register  to view this content.

hope you got the idea.

[ricdamiani]

Just a second i think i solved

[Ariff_Chowdhury]

Hi ricdamiani,
Did you check the file i sent ? anyways pasting here

Please Login or Register  to view this content.

[ricdamiani]

Hi ricdamiani,
Did you check the file i sent ? anyways pasting here

Hi Ariff,

IT WORKED!!!!
Thanks a loooooooooooot!!!!
You are the best HAHHAHA

Cheers!
Ric

[Ariff_Chowdhury]

You're welcome!
if you are satisfied with the solution provided so please mark this thread as solved! So other can reach to this easily

Thank you too

[Naveed Raza]

Hi ricdamiani

Try this..
put all the files in folder and put Goal file separtly and open the goal file and press alt + f8 and run it.