Excel Sorting Macro. Sort File A in the same order as File B

Easy concept. We have a CSV file, let's call it file A. It has customer IDs in the follwing order in column A starting with row 2:









Now we have another CSV file let's call it file B which has the customer IDs in the following order in column A starting with row 2:















What we need:

We need a macro that let's the user select the CSV A (Master) and the CSV B (To be Sorted) and then with a click of a button the file B is sorted. That's it.

Please note:

- The file B contains duplicate customer IDs. This is not to be changed.

- In file B in column B, next to the customer IDs are product IDs, in column C are quantities. In case of duplicate customer ID we need the sorting to be in decending order with the highest quantity first.

Customer ID A, Product ID, 20

Customer ID A, Product ID, 18

Customer ID B, Product ID, 34

Customer ID B, Product ID, 21

Customer ID C, Product ID, 80

- We need to do some testing with our printer. We may ask you to completely reverse the order of file B. (Printing order)

Skills: Excel, Visual Basic

See more: excel 2000 macro web, convert excel 2000 macro excel 2007 macro, excel comparing macro code, excel vba macro paste adjacent column, create excel order status file, excel 2000 simple sort macro, excel 2003 macro appent text file, excel macro sort function, build sorting macro excel, export text file excel directory macro, excel macro cut paste source destination file, excel macro vba import csv text file, input create file output excel data macro, excel sheet macro export text file, excel macro sort data existing sheets, excel vba macro file, excel macro sort

About the Employer:
( 3 reviews ) Tokyo, Japan

Project ID: #23521977

Awarded to:


Hi there! from your description, it sounds like I can do that for you within an hour. But I downloaded your files and saw File B is all Customer ID 2300070000000. I know it can have duplicates but this is not found i More

$40 USD in 1 day
(1 Review)

28 freelancers are bidding on average $101 for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community (g More

$200 USD in 2 days
(752 Reviews)

Hello, I can help you with your project - Excel Sorting Macro. Sort File A in the same order as File B I have gone through your job posting and become very much interested to work with you. I am an expert in this fi More

$140 USD in 2 days
(337 Reviews)

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 2 days
(341 Reviews)

Dear client I understand the scope of work involved in the project. I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely create t More

$100 USD in 1 day
(355 Reviews)

Hello, I would like to work on your project. I have a great experience using excel macros / vba, data formatting and data manipulation in excel. I can start right now, estimated delivery time: 1-2 hour. Let's discuss f More

$30 USD in 1 day
(123 Reviews)

Greetings sir, I have read your project details and i will develop the script to sort your csv file based on the master file. Sir, i can deliver this project sooner than you expect and will be over your satisfact More

$100 USD in 1 day
(116 Reviews)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on and I do not bid More

$140 USD in 3 days
(46 Reviews)

Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro More

$30 USD in 2 days
(79 Reviews)

Hi, I can develop a macro to sort File B according to your requirements. I think it is not required to select File A because nothing to do with this file. We can discuss about it. I am experienced Data Analyst and Ma More

$45 USD in 1 day
(86 Reviews)

Hi, I've download your files (A & B csv) and I've made the macro you need. It works well, I want to show you. What I need is your reply on chat. I'm waiting for it. Thanks

$30 USD in 1 day
(41 Reviews)

Hi there, Need to have an excel Vba that will automate the sorting of the content of a csv file that will follow the order of another csv file? I can design you an automation in Excel that will do exactly this. Ple More

$90 USD in 3 days
(12 Reviews)

Hi There I am a senior software engineer with 10 years of practical programming experience. I have excellent programming and development skills in various programming languages and frameworks. I am interested in your More

$75 USD in 1 day
(29 Reviews)

Hi there, I read your requirements and understand very-well and ready to start work from now. Hope you give me a chance to do work with you. I hope you will be kind enough to consider me for your [login to view URL] forwar More

$50 USD in 2 days
(14 Reviews)

Hi there, I just reviewed your project description and interested in your project. I can feel your project's requirements is matched with my skills because i have completed many projects in data Entry with best review More

$100 USD in 7 days
(8 Reviews)

Dear client. I can make a python script for your job. I am very well experienced in csv processing with python. Please ping me to discuss more, I will give you the best result. I can start right away. Regards.

$100 USD in 7 days
(2 Reviews)

Hi, i am expderienced in handling CSV, Ex el files and managing data. You can visit my profile. Will try to complete the work in 24hrs, worst case 48hrs.

$50 USD in 2 days
(3 Reviews)

Hello, I am an excel specialist and I would like to assist you in this project. I'll do my best to meet your needs. I hope you decide to contact me. Regards

$30 USD in 3 days
(1 Review)

Hi, I can perfectly do it. All done. I can give you. I am a data scientist with 7 years of experience. I have worked on several similar projects, and can deliver high quality code and unique design. You can see an exam More

$140 USD in 7 days
(1 Review)

~ ~ ~ PROPER BUDGET && SHORT TIME && HIGH QUALITY ~ ~ ~ How are you. i've review your post carefully and interestly. I am expert VBA. You will be fascinated by my skills. i'd like to help and finish your project. So, More

$200 USD in 1 day
(0 Reviews)

I have good knowledge on csv files and worked with excel earlier for similar projects. Can you please consider my profile. Good word accuracy and communication skills Relevant Skills and Experience Ms excel, communica More

$155 USD in 3 days
(0 Reviews)