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?
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.
Ok, do you still need help on or did you figure out how to fix you issue?
I found help, thank you though.