Cross Reference Two Spreadsheets

Hi, Would utilise a mix of IF... THEN..., FIND() and VLOOKUP functions in the code. Let me know and provide further details. Regards, Arul

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.

Hi there, I'm exert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

I can give u simple application in next few hours, which will take the 2 excel files as input and do processing on them as you have described in project description.

Hi, I can do that with either formulas or macro, and will not ask for payment until I have shown you the result ------------------------------------------------------------------------------------------------------------------------------------------

Hi Pullman. I can do the job for you in an hour. You may make the payment and award me the project after I deliver the work. I am highly experienced in this kind of work and have been doing it for years. Lets start and get it done. Regards. Usman.

I have 10+ years of experience in Excel & VBA. I can handle this easily and can provide perfect solution .

Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html IT CAN BE DONE WITH VLOOKUP, OFFSET AND SOME OTHER EXCEL FORMULAS USIND VBA CODE. PLEASE CONTACT ME. I NEED A SAMPLE FILE. Regards.

Hello! I understand what needs to be done and can do it very fast, I will create a macro to match products at first and then pull data from source file to target file for matched products. Given my 12+ years of Excel and VBA experience, it's looks like a pretty easy and quick task.

please share more details as matching can be done with excel built in functions like vlookup and few others.

Hi, I have worked as pricing analyst for 4+ years. During this stint, I have worked on projects involving elasticity analysis, break-even analysis, regression and price models. In my projects, I work extensively on excel. I have successfully completed similar projects for 'Sadebow'. You may have a look at review provided. Please revert back for any questions/clarifications. Regards! Vikas

I read through the job details extremely carefully and understand you’re required, for this I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I ll complete your project with 100% accuracy.

I am a professional software engineer. I am ready to take this work. I am an expert in excel. my skill set and experience are best suitable for your requirement. Please assign this task to me I will make sure your work will be completed 100% accurate to your full satisfaction. This work can be done in two ways and again its based on the format of the excels. 1) I can write v look up/ horizontal look up and replace functions to get the desired changes. 2) Will write script to to read both the excels data and put in another excel with the desired changes. I will run this script and send you the resulted excel to you.

Hi, I am interested in your job and ready to start. I have experience in this field for more than 5 years. Thank You.

Hi, I understand that you have list of product part number or list of them and changed the price of it. Which you need them to get updated on the excel sheet, I could do this work for you. below is the details how I am going to do it, If you have any part number for each product with the New Pricing. I will do vlookup and get it updated. or I can make if function to get the price changed. My Main concentration is to make it automated so you can use it forever, you just need to update the price going forward. It also matters how is the data look on the excel sheet which you give. may I have a look into it so i will get more idea to fix it. Please get back soon.

I'm biostatistician. Contact me And i'll make your macro with explications with you it Will be easy for me Im available

Dear Pullman I have been in this industry for 2 years and such jobs are my daily practice. I will use Vlookup formula in excel to match the records. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. I can assure you that if you work with me once, you will always work with me for these kind of projects.

I have over 15 years experience working with Excel and Office products both in my professional and personal life. For your described problem, I would either write a simple macro to do a lookup and replace. Or if necessary, write the macro to accept inputs to define the source and destination spreadsheets at run time. Thank you for you consideration. Johanna Aqui

A proposal has not yet been provided

This is not a complicated work and I could solve it, based on my experience from working with price list in my fashion company. I have been matching excel sheets for almost 2 years and hopefully it will help you. WIth my reliable communication English (98% pass rate in Freelancer US English test), I can make an thorough explanation to make sure you can understand the process. Hope to receive response from you soon.