Sedang Disiapkan

219053 Excel Spreadsheet Comparison

The requirement is for a script and or macro/engine to perform the task of comparing the contents (rows/records) of two MS Excel spreadsheets with an identical structure but different content.

The spreadsheets contain employee records that are updated on a weekly basis. The general updating practice is to overwrite the entire spreadsheet with the new spreadsheet.

The spreadsheet has 18 columns/fields and between 8,000 and 12,000 rows.

The objective of the comparison is to find differences in the employee records from week to week.

There are four main differences that are being searched for.

[url removed, login to view] employees in the spreadsheet from week one that are no longer in the spreadsheet from week two.

[url removed, login to view] employees in the spreadsheet from week two that do not exist in the spreadsheet from week one.

[url removed, login to view] employees in the spreadsheet from week one that are also in the spreadsheet from week two but who have changed location.

[url removed, login to view] employees in the spreadsheet from week one that are also in the spreadsheet from week two but who have changed phone numbers.

The preference is for a separate “Engine” to perform each of these four searches.

The preference is also for the two spreadsheets being compared to be in separate sub folders under one parent folder. And for them to have any name but the extension will always be as an MS Excel (.xls) file

The results from these searches should be written to new spreadsheets:

a. [url removed, login to view]

[url removed, login to view]

[url removed, login to view]

d. [url removed, login to view]

See next sheet for spreadsheet details.

The spreadsheets are identical in structure.

The spreadsheet has 18 columns/fields.

The spreadsheet has between 8,000 and 12,000 rows.

There are a number of columns/fields that can be used as an index or primary key.

There are also a number of columns/fields that have unique content.

(Please see below.)

1 EmpNumber Unique Primary key

2 FirstName

3 MiddleName

4 LastName

5 FullName

6 EmpType

7 Status

8 StatusCode

9 CostCenter

10 Title

11 Phone Unique

12 MailStop Unique

13 Building

14 Floor

15 Office Unique

16 EmpCode

17 UserID Unique Primary Key

18 TimeStamp

The “EmpNumber” and “UserID” are related and can be linked.

The ‘TimeStamp” field can be ignored. It is not important. It is preferred that it is ignored.

A sample of the spreadsheet has been attached to this project.

The solution can be done in either MS Excel 2003 or MS Access 2003 or a combination of both.

If the solution is done in MS Access 2003, there must be a separate Macro object for each search/comparison.

Good luck.

Kemahiran: Semua Boleh, Microsoft Access, SQL, Visual Basic

Lihat lebih lanjut: spreadsheet script, general floor, find new employees, find good employees, find an employees, find a good employee, excel macro file location, employee find, timestamp, spreadsheet 2, office macro, macro excel, macro + excel, find employees, excel to sql, excel 7, comparison of search, excel macro combination, macro script file, spreadsheet columns, building project sql, sample visual basic excel, xls visual basic, excel unique, sheet excel visual basic

Tentang Majikan:
( 6 ulasan ) Washington,

ID Projek: #1965286

Dianugerahkan kepada:

fpascual

Hello. I am very interested in your project. Hope you consider me. Thank you very much!

$75 USD dalam sehari
(0 Ulasan)
0.0