How to work on sheets of single excel file one by one

[joshikalyani]

Hi,

I'm working on a excel workbook having different sheets. I wanted to perform same action on each sheet & save output.

I'm not sure how can i input single file & use all sheets one by one to action on them.

[binuacs]

@joshikalyani Can you click the action tool and provide me the screen shot?

[joshikalyani]

[binuacs]

@joshikalyani Did you make any changes in side the macro?

[joshikalyani]

I just opened that macro, because it was showing error in macro

[binuacs]

@joshikalyani The error is fine, can you run the workflow and see you are still seeing the error or not?

[joshikalyani]

Can run it no error while running. But, it is collating data from sheets. In my file each sheet has different no of fields. And need to action each one of sheet seperately

[binuacs]

@joshikalyani Inside macro the sheets reads individually, so you can set the actions inside the macro. How you want to save each sheet after the actions done?

[joshikalyani]

Not used to Macro part, i'm not sure what changes should i do there