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
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 German, you can write me in Germa when it is more useful.
€30 EUR Om 1 dag
5,0 (3 omdömen)
2,1
2,1
10 frilansar lägger i genomsnitt anbud på €25 EUR för detta uppdrag
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, formulas, Excel VBA and finished many such projects.
Quality work with high accuracy and 100% customer satisfaction is guaranteed.
I am ready to work on this project now. Please give me this opportunity to work on your project.
Thanks and regards,
Mohan
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,
José M.
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 now.
I would like to have a discussion on chat to get more about your project.
Thanks.
Best Regard
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