Delete all the rows above dynamic row

[Manish540 (Manish Shettigar)]

Hi @Sathish_Kumar_S ,

Follow this below steps,

1. First Lookup for “User” value in excel as shown in below screenshot and get the address of the value.
   

   

2. Next use Insert/DeleteRows activity as shown below,

CInt(System.Text.RegularExpressions.Regex.Match(valueAddress,"[0-9]+").Value)-1

Hope this may help you