Do you happen to know where in the adobe or excel would that coding be done. In excel, I have already tried VBA coding. However, if you are suggesting that I do coding in VBA in excel, then I wouldn't have posted in Adobe forum on the first place as I am looking for a Adobe Acrobat Pro based solution to this. I already have succeeded in adding the bookmark in pdf created from excel for Adobe Acrobat Pro to help this "Split" function in Adobe separate the pdf when needed. (ref: -acrobat-topics/worksheet-names-excel-spreadsheet-do-not-conve... and -an-excel-file-with-multiple-worksheets-to-individual-pd... )