Hi All,
The requirement I have is to Split a consolidated file into Separate workbooks on the basis of a particular field - "Assignee Name". So for each of the Assignee there will be a workbook which will have that particular Assignee's Data in it.
But We need to write the data into a particular given template which I have shared below. So from Row 1 to 16 all the details will be provided. We have to write the data from row 17. So we have to take into Account 6 Fields. Assignee Name, Work Description, Service Country, Cost Center, Side of Books and the Last one is Total fees in USD. Line 24 in blank and the Last row will have the Summation of the Total fees as given. Also the output File name will be Assignee First name,Last name Period of invoice ( ex- Aarav Mendis-August to December 2021)
Need urgent assistance on this. Tried with many community Tasks given but not able to achieve it. Any assistance will be helpful.
