Sample : INPUT
Thank you in advance.
@Ogigi Can you provide the Sample Input File? It will be easier to find a Solution if you provide it
sorry, I’m just a new user, it says that I cannot upload attachments
@ppr it is creating new sheets, I already have sheet names named after their IDs, then I just need to get their total hours and paste it in their respective sheet name.
for example, the ID is 123, I need to get the total hours of ID-123, then paste in the sheet named “123” then same with all the IDs. Thank you
Had you rewire the output Excel path to your Excel path? It is creating new scheets, if this sheet does not exists
Also take note on this setting:
For the dynamics I would suggest to let create the missing sheets by the bots
Can it create the sheet that is missing? because the sheets needs to be equivalent to the IDs
the sheetname will be the id and will be created if it does not exist. Just play a little bit with it and delete one sheet, change an ID …
mine just creates new sheets with the sheet name equivalent to the total hours
can you share a screenshot from your xaml on this part? Thanks
@supermanPunch what if I want only the total and write it in a specific cell, what will I remove from the code?
Topic is forked to