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 
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.
I found help, thank you though.