Hi All,
My Current Workflow runs daily and is generating an output with around 40 different sheets in Excel format. What I am trying to do is if my Users want to add Investigation comments and save the output and when the workflow runs the next day I want to Vlookup the User comments from my previous day output and if that certain Reference is available the comments should populate in current out put as well.
My problem is there are multiple sheets in my Output and If I input the previous day Output file it only allows me to select one sheet, do I need to have 40 different input streams in my workflows for each sheet or is there a work around to achieve this.
I am attaching a sample Output for reference, any help is welcome as I am stuck as of now.
Thanks
