my requirement is i am having a data in excel sheet .I want to sort them as per requirement and paste in different tabs. How i can code for that can some one please help me.
Scenerio-1 In excel sheet in entitlement column the data will be present if it contains security class we need to copy all the column and row data and paste in seperate tab.below is the example
for example:ZAONLY Security Class : *South Africa Data Update (Genius)
if any entitlement name is starting with ZeroAC then we need to copy that data and paste in different tab.Below is the example.
example: ZEROAC E2 Zero Authorisation Group - Grade Level 35 : Payment Authority .00 (Genius)
scenerio 3 : other thaan security class or Zeroac string any other string present we need to paste in different tab.
example:BMCLM B1 Bermuda Claims Group - Grade Claims Controller : Payment Authority .00 (Genius)
InputSheet - Copy.xlsx (19.1 KB)