Fermé

Excel- Macro - Loop through list and check through criteria

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!

Compétences : Excel, Visual Basic pour les apps

en voir plus : create macro excel 2010 macros list, parts list macro excel, loop transpose macro excel vba, record list vba macro excel, record list macro excel vba, move record list macro excel vba, excel visual basic cut paste loop macro, excel list loop, check availability addin references vba excel macro, loop macro excel, sample macro excel category keyword list, list files directory excel macro, vba macro excel unicode, query macro excel, macro excel cells

Concernant l'employeur :
( 0 commentaires ) Sweden

Nº du projet : #12634806

71 freelance font une offre moyenne de €91 pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(252 Commentaires)
7.6
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(599 Commentaires)
7.6
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(140 Commentaires)
7.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(201 Commentaires)
7.1
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(176 Commentaires)
6.7
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(212 Commentaires)
6.8
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 5 jours
(236 Commentaires)
6.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(148 Commentaires)
6.9
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(115 Commentaires)
6.2
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(117 Commentaires)
6.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(228 Commentaires)
6.3
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(126 Commentaires)
6.5
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(121 Commentaires)
6.3
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(81 Commentaires)
6.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(61 Commentaires)
5.6
lukaszoz

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 10 jours
(23 Commentaires)
5.7
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(60 Commentaires)
5.8
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(28 Commentaires)
5.5
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(72 Commentaires)
5.8
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(25 Commentaires)
5.5