Macro to Fetch Data from Various excel files that have the same format

[umarpak123]

I am having a problem.

The problem is a simple one but I cannot seem to figure it out.

I have around 30 .xls, .xlsx and .xlsm files.

I need to fetch data from their "specific cells" that are scattered around in the 30 sheets but their formating is the same e.g. if cell of "Date of Financials" field is J7. This J7 is constant for all the 30 files. Similarly, other fields are also constant.

I need to fetch the data in a summary.xlsm file in a table form which is present in the same folder as these files. I need to make a table of data e.g.

Serial Number - Name of Client - Date of Financials - Current Ratio
1 ABC Company 31-12-2012 1.1
2 DEF Company 30-06-2012 1.5
3 HIJ Company 31-12-2012 1.8

I have figured this out for one file and it is working fine.

How to replicate this on to multiple files also accounting for the fact that data is entered in the new row for each unique file i.e. no over-writing

Please Login or Register  to view this content.

Can anyone help me out?

Moderator Note:

Pls use code tags around your code next time as per forum rules.

Also i mooved your thread in VBA sub forum.