need help on vba code which work corresponding files depends upon file name

Dear expert

i have set of data range in master A:H i want split value in a col combination of hypen values to closed workbooks of A,B,C,D,....Etc depends upon list of filenames in col H:H.

like if file name is A.xlsb in H col this code run to particular row to A workbook

Please Login or Register  to view this content.

Find the attachment.

any experts help on this need urgently!! This thread already in above my post i wrong posted twice i could delete first one so please consider this actual thread!!

Does this perform the desired operation:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

the above line should be amended to point to the directory/folder that has the "A.xlsb" and "B.xlsb' files.

So, if you have these files on your desktop, replace the above line of code with this one:

Please Login or Register  to view this content.

I'm not sure, but the Directory Path maybe case-sensitive. You have a small "f" in the code, but a caps "F" in the path mentioned. Try changing "f" to "F" in the code.

No sir its small "f" only eventhough i getting error same i wrong quoted as "F". but it doesnt contrain the small or big alphs
this is path now C:\Users\Admin\Desktop\Oracle\Forum\Scrap In scrap folder i save all files

I've amended some lines in the code and tried it with the files in "C:\Test" folder and it worked for me. Please try and let me know if anything.

Please Login or Register  to view this content.

Super sir Its working amazing!! I need save & close file A&B file once run macro complete!!

simply add the the following 2 lines of code, just before the End Sub (last line).

Please Login or Register  to view this content.

Trust your original request has been satisfactorily answered. Please mark the thread as SOLVED.

Sir last question if i add more files line up after A&B like C,D,E,F..Etc. How do i addi just try myself.
here

Please Login or Register  to view this content.

pls advice me sir

firstly, declare new variables ... wbC as Workbook ... and so on, then add suitable conditions in the code (as you identified)

Please Login or Register  to view this content.

Nice!! Amazing sir works perfectly!!!