Dear Sir,
This is my excel:
Unique ID is my main Folder - Loan_No, Link Loan No. 2, Link Loan No. 3 & Link Loan No. 2 are subfolders in Unique ID Folder.
I need Path of Folders to be: C:\Users\Admin\Dropbox\poonam\(Insert Unique ID Folder)\(subfolder name)
so Folder “Poonam” will have Folder “9814829” and subfolders “1747399”, “13132286”,”5527073”, “2989781”
the path will be like this
C:\Users\Admin\Dropbox\poonam\9814829\1747399
C:\Users\Admin\Dropbox\poonam\9814829\13132286
C:\Users\Admin\Dropbox\poonam\9814829\5527073
C:\Users\Admin\Dropbox\poonam\9814829\2989781
kindly help me with a VBA for the same at the earliest. Thank you
This is my excel:
Sr.No. | Total Link loan | Unique ID | Loan_No | Link Loan No. 2 | Link Loan No. 3 | Link Loan No. 4 |
8 | 4 | 9814829 | 1747399 | 13132286 | 5527073 | 2989781 |
10 | 4 | 9808897 | 9865324 | 3712775 | 13290211 | 1161743 |
1 | 2 | 524444 | 6477143 | |||
2 | 1 | 9353504 | 6431728 | |||
3 | 2 | 9808823 | 8386959 | |||
4 | 3 | 9355051 | 12828878 | 4161001 | 4249675 | |
5 | 3 | 9816759 | 2531911 | 2343837 | 13167967 | |
6 | 3 | 10176929 | 13640742 | 3471767 | 6170740 | |
7 | 3 | 10177845 | 13292602 | 9250468 | 3591255 | |
9 | 3 | 9899333 | 13361425 | 1931880 | 4538703 |
Unique ID is my main Folder - Loan_No, Link Loan No. 2, Link Loan No. 3 & Link Loan No. 2 are subfolders in Unique ID Folder.
I need Path of Folders to be: C:\Users\Admin\Dropbox\poonam\(Insert Unique ID Folder)\(subfolder name)
so Folder “Poonam” will have Folder “9814829” and subfolders “1747399”, “13132286”,”5527073”, “2989781”
the path will be like this
C:\Users\Admin\Dropbox\poonam\9814829\1747399
C:\Users\Admin\Dropbox\poonam\9814829\13132286
C:\Users\Admin\Dropbox\poonam\9814829\5527073
C:\Users\Admin\Dropbox\poonam\9814829\2989781
kindly help me with a VBA for the same at the earliest. Thank you