Dear experts
I have data set A:H i want split particular col values depends upon key words match as prefix
for e.g col F: prefix as Cancel,Suspension,Rejected,Out of Cash,Omission and only one value check is complete text "Acquisition-Cancellation Documentation and Media " split those data to target file in target path with particular sheets
Target file at path is C:\Users\Windows 10\Unbilling_Data.xlsx
Target sheet (Vendor_Cancel&Billing_suspend)
find the attachment clear explanation give in sheet.
expected result is Unbilling_Data.xlsx
Thanks Heaps!!
Bookmarks