This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have multiple files with 2 sheets (say A and B). The goal is to create a single output file with 2 sheets containing filtered data from A and B of each file.
I was able to create a workflow with 2 macros (1 each for A and B) which read and filter data from directory. However, I am not able to create a single output file combining their outputs. To make matters worse, when I try to write an output .xls file for a single macro (say for A), I see it has results in multiple sheets - 1 sheet for each file the macro read. I want the output file to have single sheet for all A and single sheet for all B. Any help with this would be great!
Sorry for responding late! Thanks very much for your reply and sharing your workflow.
The problem I see in using that solution in my case is that you have only 2 csv files as input. I have a set of several input files with the same 2 sheets and I'm basically looking to get an output file with the same 2 sheets but having aggregated and filtered data from all input files.
I have provided screenshots of my workflow in my other reply. Would be great if you could please take a look at it and help me.
While the join did crate a few data sanity issues which I will figure out, I now see data intended for 2 sheets A and B combined into a single sheet. Any suggestion on how I can split these into 2 sheets of a single excel file? Or at least split them into 2 files? Thanks!