Merge Excel Files eliminating duplicates

État: Closed
Prix: $75
Propositions reçues: 33
Gagnant: EmiliaSimon

Winner

Résumé du concours

I would like a quick macro to merge to two excel files of the same format but of different versions.
Identify the duplicates by certain columns and keep the values of the older version for the duplicate records found.

Updates 10/24/21:
1. Identify the duplicate rows with Sub ID, Patient Name, Date of Service and Total in Old from both excel files
2. For the rows found in both files, copy the status and other information from old file to new file
3. Create new excel sheet with copies data

- Prepare the utility
- Run it on the excel sheets attached
- Share the updated Excel sheet

Compétences recommandées

Winner

Publiez un concours comme celui-ci

Commentaire de l'employeur

“She is lovely. Only this is she never sleeps.. she should sleep more :) ”

shashikanthp09, United States.

Tableau de clarification publique

techiestc
- il y a 2 ans
I use python pandas , which is capable of doing same. If you are interested, I can write the script
- il y a 2 ans
IgeS
- il y a 2 ans
Hi there, please tell us more about your requirements - macro to loops to all the sheets and copies all data from each sheet in each file; or only selects specific sheet in each file?
- il y a 2 ans
mf12343
- il y a 2 ans
can youplease attach two sample files that needs to be merged and filtered?
- il y a 2 ans
abdulzabbar308
- il y a 2 ans
Entry No #16
Please Send Me Excel File
- il y a 2 ans
AlexDiazII
- il y a 2 ans
Entry #4 contains a video showing my solution.
- il y a 2 ans
cgullapalli
- il y a 2 ans
Hi, Please share the file and post a project and invite. Happy to help. Thanks.
- il y a 2 ans
abdulzabbar308
- il y a 2 ans
Hey Dear,
Please Share The Excel Files
- il y a 2 ans
Shyamji2001
- il y a 2 ans
hii send file i want to ready for work
- il y a 2 ans
emilynfl
- il y a 2 ans
Hi! Kindly share the excel files we need to work on. Thanks
- il y a 2 ans
MateenAfaq
- il y a 2 ans
Hi Dear, Please share your excel files..
- il y a 2 ans
architachawla16
- il y a 2 ans
Hey there! I can merge your excel files and eliminate the duplicates. Please provide the files. Looking forward to a positive reply. Thank you.
- il y a 2 ans
shubhamkumar026
- il y a 2 ans
please provide the excel files
- il y a 2 ans
supersystemng
- il y a 2 ans
Dear Sir, please provide the excel files
- il y a 2 ans
Shameemrony
- il y a 2 ans
Dear Sir, please provide the excel files
- il y a 2 ans
faisal9263
- il y a 2 ans
#guaranteed
- il y a 2 ans
malek09
- il y a 2 ans
Where's the files
- il y a 2 ans
Jayant222
- il y a 2 ans
Hi there, I can do this for you real quick.
- il y a 2 ans