Hi All,
ID PPNo PPRev PPType ATPno
710032768145 100052 37 CU 94060734
710032568145 101742 17 CU 94060734
710032761928 101788 23 CU 94074501
710034561928 101789 21 CU CON 570341
810032761998 101814 19 CU CON 570341
910032761929 102060 8 CU CON 570341
710032760058 102580 16 CU 94070293
In a folder I have files with ATPno as below
94060734.pdf
94074501.pdf
CON 570341.pdf
94070293.pdf
now the task is like if ATPno column has the file linked to different ID in column A, but I have only one file in folder, is there any way like I copy the file 94060734.pdf and get another copy and rename that new file to 710032568145_94060734.pdf and in folder I should have 2 pdf files as below
710032768145_94060734.pdf
710032568145_94060734.pdf
can any one help me out on this. TIA
Bookmarks