Færdiggjort

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:

2300069722676

2300069777249

2300069721808

2300069724090

2300069691491

2300069784636

2300069688477

2300069688040

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:

2300069784636

2300069784636

2300069784636

2300069784636

2300069777249

2300069724090

2300069722676

2300069721808

2300069691491

2300069688477

2300069688477

2300069688040

2300069688040

2300069688040

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)

Evner: Excel, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 3 bedømmelser ) Tokyo, Japan

Projekt ID: #23521977

Tildelt til:

xcelinfinity

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 Flere

$40 USD på 1 dag
(1 bedømmelse)
3.3

28 freelancere byder i gennemsnit $101 på dette job

jaylancer43

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 freelancer.com and have been featured by the freelancer community (g Flere

$200 USD in 2 dage
(752 bedømmelser)
8.5
schoudhary1553

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 Flere

$140 USD in 2 dage
(337 bedømmelser)
8.0
P0L

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 dage
(341 bedømmelser)
7.4
TonmoyRoy111

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 Flere

$100 USD på 1 dag
(355 bedømmelser)
6.9
nagyzoltan68

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 Flere

$30 USD på 1 dag
(123 bedømmelser)
6.5
ineedWorkJob

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 Flere

$100 USD på 1 dag
(116 bedømmelser)
6.4
StormLion227

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 freelancer.com and I do not bid Flere

$140 USD in 3 dage
(46 bedømmelser)
5.7
finecodervw

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 Flere

$30 USD in 2 dage
(79 bedømmelser)
5.7
vsprybhanu

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 Flere

$45 USD på 1 dag
(86 bedømmelser)
5.7
nurnga1218

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 på 1 dag
(41 bedømmelser)
4.5
IgeS

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 Flere

$90 USD in 3 dage
(12 bedømmelser)
4.5
urmate

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 Flere

$75 USD på 1 dag
(29 bedømmelser)
4.2
ravinderkumar248

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 Flere

$50 USD in 2 dage
(14 bedømmelser)
4.3
mianmuneeb1

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 Flere

$100 USD in 7 dage
(8 bedømmelser)
3.9
kozachenkodr

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 dage
(2 bedømmelser)
2.1
Prompty

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 dage
(3 bedømmelser)
1.7
manuelmata3000

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 dage
(1 bedømmelse)
1.6
pedroalonsod86

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 Flere

$140 USD in 7 dage
(1 bedømmelse)
0.5
antinivanov1220

~ ~ ~ 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, Flere

$200 USD på 1 dag
(0 bedømmelser)
0.0
krishnamenon

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 Flere

$155 USD in 3 dage
(0 bedømmelser)
0.0