Excel Macro
- or -
Post a project like this2054
$$
- Posted:
- Proposals: 1
- Remote
- #2113459
- Awarded
Description
Experience Level: Intermediate
Write a macro to compare two excel files (previous day against the following day) and display in a Word report. Items to highlight are:
Rules, When new file (21 Aug) is compared to old file (20 Aug):
1. If there are new clients in the list compared to the old file, to display "Newly on-boarded clients" followed by a table showing client's data in the form of a table.
2. If there are clients who have been off-boarded, DACS client = N but previous file was Y, to display "Recently off-boarded clients" followed by a table showing client's CIF number and Name
3. If there are clients who have had any field changed from the previous file (i.e. CRP, residency, products etc) to display "Recently updated clients" followed by a table showing all the clients with their respective details that have changed
This excel macro should allow user to select any two files to compare, an old one against a new one. and generate that report into a word document
Rules, When new file (21 Aug) is compared to old file (20 Aug):
1. If there are new clients in the list compared to the old file, to display "Newly on-boarded clients" followed by a table showing client's data in the form of a table.
2. If there are clients who have been off-boarded, DACS client = N but previous file was Y, to display "Recently off-boarded clients" followed by a table showing client's CIF number and Name
3. If there are clients who have had any field changed from the previous file (i.e. CRP, residency, products etc) to display "Recently updated clients" followed by a table showing all the clients with their respective details that have changed
This excel macro should allow user to select any two files to compare, an old one against a new one. and generate that report into a word document
Darryl T.
100% (6)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
9 Jan 2019
Singapore
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies