Dear Experts,
I want to separate the excel into multiple sheets according to the following rules:
I have the above main excel sheet and I want to separate like the following:
If the excel cells ‘Payment Date’ are merged, all the records are spearated into one sheet and if the cell are not unmerged, the record is also separated into one excel sheet.
If there is any solution or workaround, please let me know.
Hey,
You can use the switch Activity On the Basis of First Column i.e Payment Date
then you can use Append Range Activity For Appending Data
Tahnks,
Rounak
Dear Rounak, can you please give me the sample workflow for your answer.
Thanks.
Hey,
you can follow this workflow,
Sample1.xlsx (8.7 KB)
Sample3.xaml (9.8 KB)
Please let me know. if you get expected output
Thanks,
Rounak
Hey,
Please confirm you are getting expected Output which
i attached the workflow for your Reference.
Thanks,
Rounak
Hi bro. This is not the solution I want.
Hey
I have given you the reference, not the exactly as per your file.
Please take a reference and do modification.
Thanks