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)

@ramon.gonzalez

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.

@ramon.gonzalez

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