We provide the solution to this challenge using:
- Power Automate
Need a program? Click here.
This is an add-on to Challenge 36|POWERAUTOMATE – Consolidation by Cybernation.
After having finished your flow for combining all the excel files, you find out that there are now some control issues on the other end. To keep people from accessing files they shouldn’t be able to see, all the files are broken up into their separate .csv files after one person has reviewed them combined. This person is the only one who is allowed to deal with the files all combined. After he is done reviewing the entered information that it is accurate and correctly related to the other worksheets, he needs to split the worksheets into separate .csv files so he can send the specific information to the necessary people! Realizing how fast your automation worked in combining the statements, your supervisor puts you to work to write another flow to separate them to avoid any control issues. Make your supervisor proud!
Write a flow to take the combined sheets from the excel sheet and separate them back into .csv files. Be sure to rename each of the .csv files to the appropriate worksheet name. After you’ve gotten all the .csv files, make the flow close Excel.
Suggestions and Hints
- Make a list of all the worksheet names to simplify looping and referencing specific values.
- Consider using the following actions:
- Write to CSV file
- For Each loop
- Get all active Excel worksheets