Separate Excel workbook into multiple workbooks changing only one sheet, preserving others

[alowe]

Hi All,

I've been trying to create a workflow and looked throughout the community to see if anyone has done this before. I have an input excel file with multiple sheets and I need to generate multiple output files based on some filtering from one sheet in the input (SheetB in attached). Each of the output files need to preserve all of the other sheets though.

I have managed to create a workflow that can do the filtering and generate multiple files but it doesn't copy in the other sheets and all of the formatting goes missing.

Any help greatly appreciated. Attached is the input file with intended output files too.

In my current workflow I am generating a FileName formula which has wholepath+[Company]+[Country]+.xlsx||SheetB

and my output has the take file ticked at the bottom, and is set to overwrite sheet (SheetB) using the FileName parameter.

Thanks!

[DataNath]

Are you able to share your workflow/show a screenshot? It's hard to tell what's going wrong without. Just from imagining the issue, I'm wondering if you could filter out 'Sheet B' from your input and then union the remaining sheets back on to the output of your filtered results before outputting, if that makes sense?

[alowe]

Yes - apologies for not doing so before. My example is with a very small dataset, however SheetB will likely contain >100,000 rows and @~40 columns in actual production. Don't think it matters for generating the workflow though.

Thanks!

[alowe]

Doesn't look like my reply has remained so reposting here. Here's the workflow!