Jeeten Topre
New Member
- Joined
- Aug 6, 2018
- Messages
- 1
Hi I am trying to create a Macro see the below requirement.
One file name is Jeeten 20180806. I am working for different company so for each company I have smiliar workbook but in the company name floder I have saved the workbook in company folder because data are different for example ; Jeeten 20180806, Realiance 20180806, L&T 20180806.
So everyday file automatically save according to company name but dates get changes. It will always take present date.
So please let me know which code should I put so whenever I run my macro on master sheet macro will pick only present day date file not others and match with my Bank Data file which I am going to download everyday from Bank.
Another file I have saved name Bank Data. I am going to download this file from Bank and I will get smiliar kind of data. So I have to do auto matching of particular company data from Bank Data.
Like Debit account, credit account, sort code and amount should be match and give me result in the master workbook. If everything matches it should turn in Green in master sheet with data from both files. If anything wrong it's should turn red.
So please help me to know how should I consolidate data from that two workbooks in master file.
One file name is Jeeten 20180806. I am working for different company so for each company I have smiliar workbook but in the company name floder I have saved the workbook in company folder because data are different for example ; Jeeten 20180806, Realiance 20180806, L&T 20180806.
So everyday file automatically save according to company name but dates get changes. It will always take present date.
So please let me know which code should I put so whenever I run my macro on master sheet macro will pick only present day date file not others and match with my Bank Data file which I am going to download everyday from Bank.
Another file I have saved name Bank Data. I am going to download this file from Bank and I will get smiliar kind of data. So I have to do auto matching of particular company data from Bank Data.
Like Debit account, credit account, sort code and amount should be match and give me result in the master workbook. If everything matches it should turn in Green in master sheet with data from both files. If anything wrong it's should turn red.
So please help me to know how should I consolidate data from that two workbooks in master file.
