Hi There,

I would like get a macro that help me to open excel workbooks based on the name of that excel workbook and copy and paste the values in another excel file.

E.G. I have an excel file called Manual Journal Log which summarise the journals per journal. Each Journal files are saved in another folder and thees files are saved with the Journal number (e.g.STD_SV_201512040 "the description of the journal"). The journal number is mentioned in the Manual Journal log in Column C (e.g.STD_SV_201512040, STD_SV_201512041 etc...). I want a macro to open the correct excel file by referring the journal number in Column C and should copy relevant details (I can amend this if one or two lines are added in the macro!) for example, the journal value, P&L Impact, Impacted Fund etc.. I have each column for each heading in the Manual Joural log. Also, these are specified in each Journal file.

Appreciate if any help is given.

Sorry I won't be able to attach any files as those are under data protection