I need an Excel 2003 Macro or add-in or VBA program code that will do the following: There are two parts included in this bid.
This can be a macro/program that is run or some other way of achieving the same results. Finished product will be an Excel 2003 file.
Part I.
1. There are two pdf files attached to this offer. Original.pdf is an example of what the data will look like in its orginal form. The second, Modified.pdf is what the data will need to look like after it has been processed.
2. The field names are changed to those shown in Modified.pdf. Also in Modified PDF there are new fields that are added to the right. Starting with Type, then User etc. These fields will all need to be added. Currently there are about 7 fields that are added to the modified file. These will all be blank as far as data during this modification. I will provide the names and types of the new field headers.
3. The date fields need to be modified to the new format which is day/month/year, xx/xx/xxxx. The time and AM and PM needs to be removed.
4. There is a row in the orginal file that needs to be deleted. It is row 2 and is a second header.
The field called wbs_id needs to be deleted.
When completed the new file needs to look just like the old file but with the new records and data. A comparision of the new data and old data will happen in Part II.
Part II.
Once the Original file has been modified, it will need need to be compared to a modified file from the previous month.
The comparision will involve the following:
1. Provide a way for selecting the old file and the new file so a comparison can be done. This should be a browse of a selectable folder. Once both file are selected, a button should be call “Update” that will being the comparison.
2. Make a backup copy of the old file called: bu_oldfilename.xls. oldfilename should be the name of the older file selected.
3. Using the ID as the primary field, when a match is found, copy all of the data from the new fields (created in part I) to the new blank fields (Such as Type, User, Mdate etc.) in the latest copy, record by record as found. This is simply keeping the older information in the exiting records and transfering it to the new file for exiting records.
4. Identify any new records in the new file and put the current date in a field called ‘Mdate’ The Mdate field will have been created in Part I above. This field will allow me to identify any modified or added records in the new file. Also, highlite the new record as Yellow when identifing it.
3. Provide a message saying the comparison is completed.
Some simple aspects of ths job may change, such as field names etc. It should not affect the time required to do the work.