Data Extraction Multiple Workbooks And Sheets To Master Spreadsheet

[shido]

Hi All,

Refering to thread http://www.ozgrid.com/forum/showthread.php?t=135307, I have same problem and i tried to copy the same solution as provided in the mentioed thread. Either the code or the way i am following the solution is restricting me to copy the value in the desired workbook.

Can anyone have a look and make me correct please

thank you

Shido

[AlphaFrog]

You changed the FolderPicker dialog to a FilePicker dialog. I assume then you just want to copy from the one selected file rather than all the Excel files in a folder. If yes, then you wouldn't use the selected file name as a folder path.

Please Login or Register  to view this content.

This opens just the one selected file.

Please Login or Register  to view this content.

[shido]

Thanks a million AlphaFrog,

It works great and it is start picking the values but I do not know if it's break of the forum rule, if it is just say it and i will create new thread.

What I am actually wanted is to use the above code for Data Extraction Multiple Workbooks And Sheets To Master Spread sheet but I want to pick individual values from the Multiple Workbook/Sheet.

Like I want to copy rows "F13,R20,V19,AA19,AD19,AF19,AK19,AM19,AP19" from sheet 1, sheet 2, sheet 3, ........n and want to store in a Master Spread sheet. The data "F13,R20,V19,AA19,AD19,AF19,AK19,AM19,AP19"from sheet 1, sheet 2, sheet 3, ...n will be added in row 1, row 2, row 3 , ..... n in a Master Spread sheet thereby creating database for further Analysis such as Pivot Table.

Next time, when we New file is downloaded from the system, it extract new data "same defined row" into a Master spread sheet, Either it ask me to choose the next row to add the data or automatically it simply starts by adding the data from the last row i.e. (n+1) row (which ever is easier for you to modify code). Simply continue adding and creating a database for historical record.

Please find the sample file Attached.

Hope you got my point.

Thanks once again for your support and time.

Shido

[AlphaFrog]

Try this. First clear any bad data below on the US master sheet.

Please Login or Register  to view this content.

[shido]

Thank you once again, it really works well, This is the reason i love to be on this forum always get what i asked..... This is what i was looking for except, do not know what you mean by clearning any bad data.? do you mean to clear any Nil or alphanumeric values in the Master sheet?
Thanks once again
Cheers and keep doing good work.

[AlphaFrog]

In your example Disire Result.xlsx workbook, the US sheet had some bad data on it from the previous macros below the desired results.

[shido]

Dear AlphaFrog,

Thanks for pointing me out to the right direction and keep it up.

Cheers

Shido