Macro to compare two sheets and match items automatically

₹600-1500 INR

Opravljeno

Objavljeno

pred približno 8 leti

₹600-1500 INR

Plačilo ob dostavi

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

ID projekta: 10161794

Več o projektu

15 ponudb

Projekt na daljavo

Aktivno pred 7 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@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 v 1 dnevu

5,0

(1 ocena)

0,2

15 freelancerjev je oddalo ponudbo s povprečno vrednostjo ₹1.397 INR za to delo

@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 v 3 dneh

4,9

(264 ocen)

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 v 1 dnevu

4,8

(186 ocen)

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 v 0 dnevu

5,0

(136 ocen)

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 v 1 dnevu

5,0

(120 ocen)

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 v 1 dnevu

4,9

(140 ocen)

5,9

@The24CarrotsInc

A proposal has not yet been provided

₹700 INR v 1 dnevu

4,9

(71 ocen)

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 v 1 dnevu

4,9

(90 ocen)

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 v 1 dnevu

5,0

(54 ocen)

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 v 0 dnevu

0,0

(0 ocen)

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 v 1 dnevu