Paste entire row after finding specific cell utilizing lookup range

I have a list of names on a worksheet. Each row starts with a name and then has other information in the rest of the columns on that row. I currently have a “do while” setup (do while counter < 40) where the robot stores A+counter in a variable Name and then copies the entire row using read row (i’ve also tried read range). i then go to another sheet in the same workbook and find that same name using lookup range and the variable Name. this works and give me a specific cell (like A19). I would then like to print the entire row (that I have already copied from the previous sheet) but am having trouble figuring out how to do it. is there anyway to separate the a from 19 so that i can print each instance in the readrow into B19, C19, D19 etc. or is there a better way to do this? Any help would be really appreciated

Not sure , if i undertstood your full question? but on the above piece, you can use regex to extract the numeric with this simple pattern…

StrExtract = Regex.match(Lookuprangeoutputstring,"\d+").value

Here StrExtract is of type string

Thanks a lot for your help!!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.