VBA & Excel - Compare, Count and sort
€8-30 EUR
Оплачується при отриманні
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
ID Проекту: #18646362
Про проект
Доручено:
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 Більше
10 фрілансерів(-и) готові виконати цю роботу у середньому за €25
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 Більше
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
Send me details and get your VBA done. I have all that skills you're looking for. I believe more on working than talking
Hi For your requirement kindly accept my bid Cost 50 EUR Delivery within 2days Kind Regards
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.
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