Đang Thực Hiện

VBA Import source, perform calculations and modify and export

I have an excel file with different sheets. There are sheets for each month, starting at 1 (January) until 12 (December). In each of these sheet are entries for the specific month. There is a sum calculated. This is simply sum over all days of this month for this specific ID. The column sum is called „Summe“. In the file provided it will start at C2, so the header is in C2 and values are below. (It should be possible to let the user specify the exact column, in case it is needed, see attachments).

Task is now to (with VBA code):

1.) Extract the categorization:

The categorization (later on used) is determined by taking the last 4 digits from the key column. Add this to the sheet, after name column. Should be named "FASC". The values need to be displayed properly, so there should be "0000", and not "0" displayed. This could be done as pasting as text. (Or number with specific format to display the zeros.)

2.) Get the „Betten“ column

The column called „Betten“ should be given in the same file, however in another sheet. The name of the column should be assumed to be "Betten", otherwise the user has to specify the column where it can be found. The sheet where the basic data is located should be assumed to be the first sheet of the file. Otherwise the user has to specify the name of the sheet where the basic data is stored (if the first sheet oft he file is not possible to program in vba, then the user always has to specify the column manually).

The „Betten“ column needs to be added to the current month sheet. So let's assume it is september. Therefore the value from the column „Betten“ for each matching ID has to be copied and pasted in the the sheet 9. This needs to be done for matching ID. The IDs given in basic data have an additional prefix 70 and are given in text format. The ID in the corresponding month sheet, so for example month September is the sheet called 9, is given without the prefix and is displayed (I think) as text. These values were not entered as pure numbers, these are references from another sheet, check attachment. (But I think it is to be handle das text, not sure.?). The ID column is assumed to be named „RENR“ in the basic data sheet and in the corresponding month sheet, it is just assumed that it is in column A and the values start in A3.

3.) to insert an additional column before the sum column (after the categorization column created in step 1) which is named "Max" and calculated as follows:

Max = Betten*30/factor

„Betten“ is specific for each ID. The factor is a lookup into another file. This other file gives for each category a specific factor, so this is an easy lookup. This factor has to be used for the calculation. It is important to not limit the range, as I don’t know, how large this file will be, so I don’t know how many different factors will be in this list (how long the list will be).

Check attachments.

If „Betten“ is missing for a specific ID then the calculations cannot be done and "Bettenangabe fehlt" should be entered. If factor is missing, "Richtwert fehlt" has to be put as text.

4.) mark those values in column sum as red, which are larger (or equal) than this max value. If „Betten“ is missing set background color yellow.

The final file should be stored as a new result file. However, there should be an option in the vba file (see attachment) where the user can enter „gefiltert“ or „komplett“ to have different options of output. In case of „komplett“ the complete file should be created. In case of „gefiltert“ there should be a filter applied on the column sum. Furthermore only the values marked as red (see step 4, so >=max) should be displayed (marked as red of course).

In regard to point 2.) there is one further thing:

Space is limited here and therefore I cannot enter more, please check attached description file along with the other files, in order to see the complete specification!

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, Xử lí dữ liệu

Về Bên Thuê:
( 0 nhận xét ) Berlin, Germany

ID dự án: #21277170

Được trao cho:


Dear Sir, I'm interested in your project. I'm willing to work before you hire me. I'll consider it a practice if you reject my work. Please pay me only after fully satisfied with my work. Thank You J Felix Bosco

€150 EUR trong 2 ngày
(7 Đánh Giá)

40 freelancer đang chào giá trung bình €178 cho công việc này


Hello, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community ([login to view URL] Thêm

€222 EUR trong 3 ngày
(730 Nhận xét)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Thêm

€200 EUR trong 5 ngày
(333 Nhận xét)

I'd be happy to help you with this project. I'm experienced with all Excel functions including advanced formulas and macros and I have an excellent record of quick turnaround time. If you would like me to work with yo Thêm

€200 EUR trong 2 ngày
(264 Nhận xét)

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.

€200 EUR trong 5 ngày
(314 Nhận xét)

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel macro that will follow the actions that you mention. I plan to use a com Thêm

€200 EUR trong 5 ngày
(226 Nhận xét)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Thêm

€200 EUR trong 7 ngày
(235 Nhận xét)

Hello, I would like to work on your project. I have great experience using excel macros / vba, data formatting and data manipulation in excel. I can start today if you like so. Regards.

€175 EUR trong 5 ngày
(121 Nhận xét)

Hi, You may not select the right candidate without knowing what your project on developing Excel VBA for your Excel file that for importing source, performing calculations, modifying and exporting data will look like. Thêm

€170 EUR trong 5 ngày
(50 Nhận xét)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible Thêm

€200 EUR trong 2 ngày
(116 Nhận xét)

VERY EASY FOR ME Hi, Nice to meet you. When it comes to Excel, MS Word, Google Sheet, VBA, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/ Thêm

€175 EUR trong 1 ngày
(49 Nhận xét)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Thêm

€200 EUR trong 2 ngày
(120 Nhận xét)

I have more than 10 years of experience in Excel and VBA with 100% client satisfaction history. I have gone through the detail of project in attachment as well and I can complete it very efficiently. Looking for your r Thêm

€200 EUR trong 5 ngày
(35 Nhận xét)

I am postgraduate with more than 6 years of experience in advanced excel based tools, web automation, macros, VBA automation, Google spreadsheets, Google scripting. I have completed similar projects, please have a look Thêm

€277 EUR trong 3 ngày
(33 Nhận xét)

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

€200 EUR trong 7 ngày
(35 Nhận xét)

Hi, I have understand the project requirement & interested to make and modify vba for this project. Please send a message so we can discuss more & start the project. Thanks.

€150 EUR trong 3 ngày
(24 Nhận xét)

Hi, I can write you a neat VBA code to perform these tasks perfectly as exactly as you describe. I guarantee my VBA code (no payments if this code doesn't work) and will support it even after the project done. I have r Thêm

€200 EUR trong 3 ngày
(30 Nhận xét)

Dear Client, I can do this Job. I have excellent experience of Excel (VBA/MACROS/FORMULA'S),Data entry, Web Scrapping (Python and Selenium) and Web Research for more than 4 Year’s. Never ends up until you are 100% sa Thêm

€160 EUR trong 2 ngày
(24 Nhận xét)

€ 150 Only ------ In Just 2 Days------ Excel Data Entry, VBA Macro & Formula Generation Expert ------ 100% satisfaction first, then payment.

€150 EUR trong 2 ngày
(28 Nhận xét)

I can do the job and I can start right away! I read project description and looked at the attached sheets. I can do all the operations described there, If you award me I will ask any doubt that may appear while working Thêm

€150 EUR trong 5 ngày
(14 Nhận xét)

Hi, I can write such programme in less then 4 days. Also base on your description I think you need a programme like vbafile attached, user will specifies the setting of the programme in this file, if user press "Automa Thêm

€175 EUR trong 4 ngày
(7 Nhận xét)