Hi everyone, I would like to ask if there is a way on how to capture data in a multiple cells in a row in an excel spreadsheet and put it in a variable to be use for another purpose (like paste it in another excel spreadsheet in another workflow or sub-workflow).
Below is a sample scenario, the workflow will loop in column A (Served), look for the row with a "Yes" string then capture the data in columns B, D & E in the same row, then in another worksheet search for the first blank row in the Item Id field and paste the data.
Thank you,
@jogu
Hope this is what you you need.
Thanks @Qiu for your prompt reply. Can I put this in a loop so that all the users in another worksheet will be filled by the data from the other worksheet?