Macro to copy paste & close cell values from multiple files

[balaji3081]

Hi All,

I have to reconcile two sets of files in different folders on a monthly basis, currently I open each file apply filter if required and paste value in the recon file.

Takes a long time manually.

I have attached a template , where -

- Folder path is mentioned in cell C3 & O3
- File name is in col C (C7 to C11) & O (O7 to O11)
- For LOB files need to apply repective filter in each file ( mentioed in col D)
- From All LOB files need data from Cell H26 to M26 to be copied in the recon file
- From P&L file find value on Col F for Text as - "Net Expenses" and copy from Col H - M, for eg if Net Expenses in on row 26 then copy paste from cell H26 to M26

Thanks

 

[balaji3081]

Few more points -

The two file sets - LOB & P&L are in different folders and the path needs to be called out in Excel cell C3 & N3

the file names are in mentioned in col C & N

and the extension is .xls

Appreciate if anyone can provide a quick help

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Macro to copy paste from multiple files - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.