Firstly, I grab the Serial number = F38290W5800013 (which is in charge by “RPA”) into the system.
I’d like to copy some specific values back to the excel every time the sheet shows up in the system.
For instance, there’re “Country, Evnt Dept, and Report Dept” in the system.
I’d like to copy these three values (“U.K., ddF Section, and XYZ Section”) and paste to the related row in respectively which are all based on Serial number = F38290W5800013
Get text value is ok to use extract values from the defined fields in the UI. my suggestion is before writing the value in excel cell using write cell ativity direclty insteda of use lookup range activity by giving input serail number to get the exact cell value so that we can use the dynamic cell value to enter the values for the other columns like Envt Dept,Report Dept, Country in the correct cells. by using lookup range we wont miss the correct cell values. please try.
Pardon me
I didn’t know your meaning at
“by giving input serail number to get the exact cell value so that we can use the dynamic cell value to enter the values for the other columns”
Is it possible for you to use screenshot or something to present this part?
Appreciate for your reply
above image is just for your reference. what i am trying to say is instead of directly using write cell first use lookup range to get the dynamic cell value from excel where the reference is there and use write cell to enter the values for fisrt three columns Ënvt Dept", “Report Dept”, “Country”. Hope this post helpful for you. if it is not i am sorry i am not getting your issue.
In range of writecell activity use column name+dynamic cell value which you recieved as output eg:A12(A-columnname & 12-rownumber from lookup range) from the lookup range activity. Please note that you will receive output for lookup range you would get column name and cellvalue. Eg:E12 You have to use replace activity to replace column name with empty so that you will get only 12 as output. So that you will get only cell value.
I hope you will achieve. Incase you still face issue. I will create small workflow and share it with you.
I’ve tried to use Replace activity, but it still has no value show up in excel.
Perhaps help me create a workflow so that it’d be easy to operate in UiPath.
