Consolidate Excel file

Hi, I am currently trying to consolidate two sheets from an excel file into a new file based on the current date, it should display the bank, account number, date and balance. I am unsure how to do this so can anyone help?

Here are the excel files and the workflow that I thought would work:
SaldoBancosIndividual.xlsx (9.6 KB)
SaldoBancosAppend.xlsx (8.5 KB)
Consolidation_Helper.xaml (10.1 KB)


Hello, try to do it your self first, if you get stuck on what ever, i ll be glad to help !

Check below link, you will find your solution :point_down:

It’s not my solution though, all that does is merge so if I have 200 values in file 1 and 300 on file 2 they will get combined and put into the output file which doesn’t help. The output file ONLY needs to contain the values-based by Date.Now.ToShortDate. It has the right idea and had already tested this way but thank you for your help.


Ok, do you still need help on or did you figure out how to fix you issue?

I found help, thank you though.

1 Like