I have a FOLDER with 40 excel files, all have the same structure and a sheet named “Información”
I want to take the value for cell “B1” inside each excel file and be used to rename the “Información” sheet.
Hi Yoichi… after this, I want to move forward on deleting the fisrt 4 rows, again for each file in the first sheet.
I tried to use your same workflow , after “use excel file” I added the “delete excel row” but I,am lost about how to specify like for each current sheet.
Thanks! one question I just tried and get an error “Rename Sheet Value Cannot be null” … since now all the “fisrt” sheets were renamed, so no longer named “Información”, do I need to specify some way that I,am refering to make the deletion on the FIRST SHEET?
Hi, thanks!
The situation is that it is working fine with the first file, deleteing the rows, but then for the next excel file, it added a new blank sheet with the name of the previous file, instead of delete the rows on the first sheet of the 2nd file… attached an image for better explain.