VBA or other Matching Program for comparing spreadsheets
- or -
Post a project like this1470
$49
- Posted:
- Proposals: 41
- Remote
- #2764027
- Awarded
307776438901063269278329146935377393684847369400538268283834160386255538867403984959
Description
Experience Level: Entry
I need a specialist that can work on a matching program of sorts in VBA or something better. I have heard that VBA may go away, and would be open to other ideas on how to do this.
The reason I am needing some sort of Macro/Program is that I need to be able to hand this off to contractors without too much training and/or explanation.
Formulas can get complicated, especially when you are trying to match on more than one column.
I need to be able to take two spreadsheets. (which may look a little different than what I provided here), and choose which columns to compare, for instance: Compare Supplier ID, Name, and Account number column on Spreadsheet one, with the same on Spreadsheet 2 (different columns on the different spreadsheets have different names).
THEN I need it to spit out only what is missing on the two sheets to a 3rd sheet (Spit out full row).
I have been unsuccessful with VLOOKUP formulas (I am an amateur when it comes to formulas and find it only helpful when I am comparing for one column), and I do not know much about pivot tables, though I have heard it could be my solution.
I am open to pivot tables if we can create something that makes it EASY for an amateur like me or someone that doesn't have much experience at all to create on a whim when the two spreadsheets can vary so often.
I have an old program that was built for me that I am adding on here as well. This still might be too complicated for entry level users, but is on the right track with what I am looking for. (Although, again...maybe not in VBA? Open to suggestions). **It would not let me uplaod a .xlsm file. I will post a file of what was written instead, and if you want me to send you the program let me knwo**
Thank you and look forward to hearing from you!
The reason I am needing some sort of Macro/Program is that I need to be able to hand this off to contractors without too much training and/or explanation.
Formulas can get complicated, especially when you are trying to match on more than one column.
I need to be able to take two spreadsheets. (which may look a little different than what I provided here), and choose which columns to compare, for instance: Compare Supplier ID, Name, and Account number column on Spreadsheet one, with the same on Spreadsheet 2 (different columns on the different spreadsheets have different names).
THEN I need it to spit out only what is missing on the two sheets to a 3rd sheet (Spit out full row).
I have been unsuccessful with VLOOKUP formulas (I am an amateur when it comes to formulas and find it only helpful when I am comparing for one column), and I do not know much about pivot tables, though I have heard it could be my solution.
I am open to pivot tables if we can create something that makes it EASY for an amateur like me or someone that doesn't have much experience at all to create on a whim when the two spreadsheets can vary so often.
I have an old program that was built for me that I am adding on here as well. This still might be too complicated for entry level users, but is on the right track with what I am looking for. (Although, again...maybe not in VBA? Open to suggestions). **It would not let me uplaod a .xlsm file. I will post a file of what was written instead, and if you want me to send you the program let me knwo**
Thank you and look forward to hearing from you!
Chantel G.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
2 Sep 2017
United States
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