Đã hoàn thành

Develop an Excel Macro to sort product posts alphabetically in an excel file

For manipulating our product file, we will need to first export it from our online store. However, our online store is not capable to export the data in a correctly sorted manner.

This project is about creating an Excel macro that converts an unsorted product file from a given format in Excel (Source file) to an alphabetically sorted format also in Excel (Output file). Below is important notes for sorting the products correctly:

• Each product may have one or more lines of data. Let’s call these lines a “Post”. In the attached excel file, I have marked a few product posts in the beginning of the file with light and dark blue. The column A (Produktnummer” defines which lines belong to the same product post. For example:

o the first product has the product number KV00-C034 and is defined by lines 2 to 15, (as all these lines have the same value in their “Produktnummer column”).

o And the second product has the product number 5725 and is defined by lines 16 to 18.

• The posts must be sorted according to following:

o First sorting criteria is according to column J, “Produktgruppens namn”. For example, all products that have the value “Canvastavlor” must be sorted so that they appear in the beginning of the product file. And all products that have the value “Fototapeter” must be sorted so that they appear after all “Canvastavlor” products (because F comes after C). And so on.

o The second criteria is according to column K, “Undergrupp nivå 1”. This means for example within “Canvastavlor” products are sorted according to the value in column K.

• When the posts (products) are sorted, all lines in a post must remain together and in the same order. In fact, no change at all, is permitted within a product post. An entire post, unchanged, must be sorted. No sorting within the post itself.

Notes:

• You need to have strong knowledge in Excel and writing codes for macro to be able to perform this task.

• The macro must allow to brows and select the source file. The output file must be saved with a new filename in the same folder as the source file.

• Our excel file is in Swedish language and all the Swedish language characters must remain correctly intact in the sorted file.

• I have uploaded a sample for the source file. The full file can have more than 100, 000 lines.

• If you require more details than this document to be able to perform the task, and to avoid lengthy chats, we might need to share screens in one or more online meetings to discuss your questions.

Kĩ năng: Excel Macros, Excel VB Capabilities, Excel VBA

About the Client:
( 9 nhận xét ) Farsta, Sweden

ID dự án: #32750090

Được trao cho:

(51 Đánh Giá)
6.3

26 freelancer chào giá trung bình$130 cho công việc này

(65 Nhận xét)
7.7
(172 Nhận xét)
7.1
(61 Nhận xét)
6.0
(5 Nhận xét)
5.9
(31 Nhận xét)
5.6
(50 Nhận xét)
5.7
SShtv

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These Thêm

$175 USD trong 3 ngày
(33 Nhận xét)
5.6
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Thêm

$40 USD trong 1 ngày
(10 Nhận xét)
4.7
(25 Nhận xét)
4.8
(8 Nhận xét)
4.9
(24 Nhận xét)
4.4
kingqueen369

Hi, Greetings! ✅checked your project details :clear Attachments Sample unsorted file for [login to view URL] ✅Completed Time : 24 hours or your requirement deadline . ✅✅I haven't worked for a few days for my exams and il Thêm

$70 USD trong 1 ngày
(8 Nhận xét)
3.9
MamukaB

Good Day I read instruction and check source file and think I can do this project well. I can add to select more then 1 file and consolidate all data or make separate output for each file. As your needs. I have 15+ ye Thêm

$112 USD trong 2 ngày
(2 Nhận xét)
3.8
(12 Nhận xét)
3.8
(1 Nhận xét)
3.0
(5 Nhận xét)
2.7
(3 Nhận xét)
1.9
(1 Nhận xét)
1.2
sadiimalik

Hello, I will be glad to help you in this Sorting values project using Excel Macros with accuracy and in the given time frame. I have strong knowledge and experience with excel VBA and I hope you will be happy. pleas Thêm

$80 USD trong 7 ngày
(1 Nhận xét)
0.4
carina0530

Hello, I'm fullstack expert, with over 10 years experience dealing with web, I can help sort by excel macro. I've previously worked on the exact similar project for American Rudy employer. When do you need this fi Thêm

$140 USD trong 7 ngày
(1 Nhận xét)
0.0