Hello Forum users!
I have a problem how to define specific position for paste information.
This process will be based on REF and I have in my mind dispatcher to recognize what is this week monday date(you can find same date in collum B in excel - attached picture). Store it in a queue. After that performer take this information and base on this find correct row(same date in collum B) in excel file(attached picture).
Do you have an idea how to store actual week´s monday date ( this week is calendar week 35 that mean that this week monday was 30.8.2021) in to queue ? I know how to store via “Reference/collection” of “Add Queue Item” but how to recognize actual week´s monday date is the question.
Thank you for your ideas
Here you can see the picture of file what am workin with