VBA & Excel - Compare, Count and sort

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

Hello Freelancer,

I need a VBA Excel expert. Implementation: ASAP

I have a spreadsheet in Excel with the annual billing of an account, see [login to view URL]

This spreadsheet is named "total"

Task:

Write a VBA script to automate data sorting, spreadsheet creation, comparing, summation.

1. See "[login to view URL]". You see a table with values. Most are irrelevant. See column E:

For each text with the same content from E8 to the last entry in column E: macro should create a new spreadsheet with the naming of the content inside the column, not longer as 12 signs

a. Example: you see Company 1,2,3 + Firma XY = 4 new spreadsheets. Text content in generic, not only company etc.

2. Copy now all columns of B-L which have the identical content of column E into the corresponding spreadsheet, beginning with column A

a. For example: You see in "[login to view URL]" three times "company 2" in the total spreadsheet. So the macro in the worksheet has to insert the values in "Company 2" as shown in "[login to view URL]".

3. Then calculate the sum (summe) from column H, see also "[login to view URL]". Leave a row blank for distance.

4. See "[login to view URL]" again

In spreadsheet “total” in column A: make a comparison, are all values from column E in “total” spreadsheet right copied in the other spreadsheets (compare with column D in other spreadsheets). Work with colors. Green: ok, red: not ok

5. Macro should create a new spreadsheet, called “Uebersicht”. Show in column A all spreadsheet names, in column B: all total sums from point 3.

That’s all

Thanks

Введення даних Обробка даних Excel Visual Basic Visual Basic для додатків

ID Проекту: #18646362

Про проект

10 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

Доручено:

KozlouAlex

Hello. Here is example Excel VBA project completed by me recently. https://www.freelancer.com.ru/projects/project-18606057/ I will be able to prepare VBA script for this task this during 1 day. BTW i speak Ge Більше

€30 EUR за 1 день
(3 відгуків(-и))
2.1

10 фрілансерів(-и) готові виконати цю роботу у середньому за €25

TechnoGuruu

Hi, As per requirements I will develop VBA macro for you which will create new sheets and will move/calculate the data as per description of the project. Please share your Excel sheet. I have expertise in Excel, for Більше

€30 EUR за 3 дні(-в)
(60 відгуків(и))
5.4
Baderah

I am a quantitative analyst and an expert in Ms Excel and VBA programming. Therefore, I can aptly undertake your work. For more details, contact me

€19 EUR за 1 день
(19 відгуків(и))
3.5
JMMachado

Hi, I think I can help you in this project. I have 20 years in the development of Ms. Excel spreadsheets, including pivot tables, graphs, formulas, macros and VBA programming. I'll be glad to help. Best regards, Більше

€20 EUR за 1 день
(2 відгуків(и))
3.0
chraheelbhatti

Send me details and get your VBA done. I have all that skills you're looking for. I believe more on working than talking

€9 EUR за 1 день
(3 відгуків(и))
3.0
ludwig333

Hi. i am a full web developer with over 5 years on freelancer.com. I have read your description and have interests in your project. I have rich experiences in projects similar to yours. I am ready for your project Більше

€30 EUR за 1 день
(0 відгуків(и))
0.0
Mdameir6

Give chance for a professional work

€23 EUR за 1 день
(0 відгуків(и))
0.0
mlotfy1180

Hi For your requirement kindly accept my bid Cost 50 EUR Delivery within 2days Kind Regards

€50 EUR за 2 дні(-в)
(0 відгуків(и))
0.0
Abraha91

hi, i see your description, and this job can be done in just 1 day, with high output quality, and it will cost you 22€, hope to choose the right lancer.

€26 EUR за 1 день
(0 відгуків(и))
0.0
behrammalghani1

i can handle this project and i also have done this type of work in a company where i am still working your work done on time give me a chance to prove my skills

€12 EUR за 1 день
(0 відгуків(и))
0.0