Macro to compare two sheets and match items automatically

₹600-1500 INR

Abgeschlossen

Veröffentlicht

vor etwa 8 Jahren

₹600-1500 INR

Bezahlt bei Lieferung

I have two spreadsheets. Spreadsheet A - columns are model number1, model number2, model number3, title, item code Spreadsheet B - columns are model number1, model number 2, title. I want a macro to search for matching values of model number1, model number2, model number3 from spreadsheet A with whole column value as well as part of column value in model number1, model number 2, title. Vlookup is enough to find the whole column value match but to find part of column value I have been using filter function which is time consuming. The macro should find match and enter respective item code of Spreadsheet A in new column of spreadsheet B. I am looking for someone who can do it perfectly and has done such macro before. I assume it would not take more than an hour for someone who is well versed with macro.

Excel

Visual Basic

Projekt-ID: 10161794

Über das Projekt

15 Vorschläge

Remote Projekt

Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

E-Mail-Adresse

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest

Für Ihre Arbeit bezahlt werden

Skizzieren Sie Ihren Vorschlag

Sie können sich kostenlos anmelden und auf Aufträge bieten

Vergeben an:

@ExcelPowerpoint

Hi I'd love to assist you with a professional Excel Dashboard Since I am new on Freelancer.com, you won't see any reviews. This will be my first order here. I want to build a good profile on Freelancer.com and therefore you can be assured that I'll put in the right efforts to do justice to your order. Please feel free to reach out to me if you need any more samples of dashboards. Please download a sample of my work which is very relevant to your project: [login to view URL] Please feel free to message me if you need any assistance. Looking forward to work with you. Thanks Monal

₹1.000 INR in 1 Tag

5,0

(1 Bewertung)

0,2

15 Freelancer bieten im Durchschnitt ₹1.397 INR für diesen Auftrag

@paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

₹2.100 INR in 3 Tagen

4,9

(264 Bewertungen)

7,6

@cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/

₹1.500 INR in 1 Tag

4,8

(186 Bewertungen)

7,1

@nagyzoltan68

Hello , I would like to work on your project. I have great experience using excel and macros / vba. My strongest part is data manipulation in excel through vba code. I have had similar works done before. Provide please details in PM. Thank you. Regards

₹1.200 INR in 0 Tag

5,0

(136 Bewertungen)

6,6

@katilinas

I CAN do this job, and do it well! If you look at my portfolio you will see that my skills are a good fit. Do You need a freelancer who can fulfill all of your requirements? IF SO, push the button "Hire me!" - I think it will be the beginning of a good partnership!!

₹1.150 INR in 1 Tag

5,0

(120 Bewertungen)

6,6

@vlayausa

Hello, I have a lot of experience with this kind of projects. I am proficient with Excel and VBA and I could easily make this macro for you. Please contact me for more information.

₹1.300 INR in 1 Tag

4,9

(140 Bewertungen)

5,9

@The24CarrotsInc

A proposal has not yet been provided

₹700 INR in 1 Tag

4,9

(71 Bewertungen)

5,8

@archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance calendar and calculator You can see the reviews of the same in my profile

₹1.500 INR in 1 Tag

4,9

(90 Bewertungen)

6,0

@prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,Yellowpages,Yelp,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction, and the price is negotiable if required. please award me this project and contact me for further details

₹1.500 INR in 1 Tag

5,0

(54 Bewertungen)

4,7

@Noctivagus

This is part of my day job. I can deliver it quickly and, if any adjustments are necessary, I can do it without further expenses.

₹950 INR in 0 Tag

0,0

(0 Bewertungen)

0,0

@trinsaur

There are ways not to use filter by using vlookup. If there are keys created in both spreadsheets for vlookup, you might not need to use filter. In case you would need to use filter, there is a better way to do so which can help you improve programming performance. I can help you control the rows to be used for lookup or automate the process if needed. This will be a macro taking less than a hour. Please let me know if you want to know more.

₹1.300 INR in 1 Tag