Excel- Macro - Loop through list and check through criteria

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

If you are an Excel/VBA expert, this task is going to be really easy for you! We have a list of entries with attributes such as the relevant time period/ which country/ campaign type/ category they belong to.

The goal of this project is: I want to request a time range (e.g. calender week 50) and see all the costs in this period in total. However, I also need to be able to request costs in a period for a specific country and a specific campaign type.

Example:

E.g. I am asking for the costs from 01.01.2016-15.02.2016 for all countries=DE (column J) and Campaign = ST (column K) and in the category = a (column N)

To have a good grasp of what I am talking about, please feel free to dive into the attached Excel workbook.

If you are doing a great job, then we will send you 3 really similar tasks, as well!

What do you need to provide?

- Be an Excel/VBA Ninja and a great communicator!

- English proficiency: We need to be able to understand each other

- Be on time with the schedule as this is really not a difficult task :)

So ready? Ok, great!

Excel Visual Basic для додатків

ID Проекту: #12634806

Про проект

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

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

cgullapalli

Hi, I am good at Excel and vba. Plz provide me the details further to get the scope of work. Looking forward to discuss in the chat.

€33 EUR за 0 дні(-в)
(700 відгуків(и))
7.7
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Більше

€250 EUR за 2 дні(-в)
(231 відгуків(и))
7.4
someka

Hi there. Look no further! :) . As being one of the highest rated Excel & VBA Ninja in this platform, I can work on your job. What I will do is create a VBA macro to check the criterias and list you the final results. Більше

€85 EUR за 2 дні(-в)
(141 відгуків(и))
7.1
aarifakhtar

Hi: I understand that you looking to have a custom filter based on country and time period which would allow you to filter data based on the input. Please note that over 80% of my completed projects are related to Exce Більше

€34 EUR за 2 дні(-в)
(153 відгуків(и))
6.9
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

€50 EUR за 3 дні(-в)
(264 відгуків(и))
7.0
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

€250 EUR за 5 дні(-в)
(247 відгуків(и))
7.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Більше

€55 EUR за 0 дні(-в)
(195 відгуків(и))
6.8
kolosibalint

Hi, I have been working as a BI analyst for 4 years working mostly with Excel including automating tasks in VBA. What you need is indeed relatively easily. All you need is a pivot table with filters. I can come ba Більше

€100 EUR за 1 день
(96 відгуків(и))
6.4
watersev

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only. As far as I can judge on the provided data sample you can avoid using VBA sol Більше

€34 EUR за 0 дні(-в)
(243 відгуків(и))
6.4
asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well Більше

€155 EUR за 3 дні(-в)
(60 відгуків(и))
6.3
ksriniravi

Greetings! For some reason, I was not able to download the file. However I do understand your requirements. I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemen Більше

€50 EUR за 1 день
(142 відгуків(и))
6.5
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Більше

€60 EUR за 3 дні(-в)
(133 відгуків(и))
6.6
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Більше

€50 EUR за 3 дні(-в)
(115 відгуків(и))
6.2
shikhamehta

Hey, I am an expert in Excel and reviewed the workbook you shared. There are more than one ways to accomplish the kind of filtering you are looking for. We could go for a macro based approach that will allow you to Більше

€111 EUR за 1 день
(128 відгуків(и))
6.5
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y Більше

€30 EUR за 3 дні(-в)
(65 відгуків(и))
5.9
osmemon

I have been involved in excel for the past three years. Very well versed in VBA and Macro. The requirement mentioned in this project can be easily done and I am familiar with it. Looking forward to your reply

€30 EUR за 1 день
(33 відгуків(и))
5.6
kevivu

Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews Більше

€34 EUR за 2 дні(-в)
(72 відгуків(и))
5.8
KavTan

I am an Expert in MS Office, can be a useful asset to your kind of project with faster resolution and Complete satisfaction. Sample Work: https://www.freelancer.in/u/KavTan.html

€90 EUR за 1 день
(37 відгуків(и))
5.3
abdolah2014

HI I am an excel-vba Expert and I can finish your project so fast start the chat to discuss more .........................................................................................

€111 EUR за 3 дні(-в)
(37 відгуків(и))
5.3
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and Більше

€263 EUR за 3 дні(-в)
(13 відгуків(и))
5.1