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 [url removed, login to view] 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

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

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

150 € EUR en 1 jour
(247 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.

33 € EUR en 0 jours
(316 Commentaires)
7.0
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

85 € EUR en 2 jours
(121 Commentaires)
6.8
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

55 € EUR en 0 jours
(162 Commentaires)
6.6
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

34 € EUR en 2 jours
(130 Commentaires)
6.7
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 en 5 jours
(207 Commentaires)
6.7
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

111 € EUR en 1 jour
(123 Commentaires)
6.3
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 en 3 jours
(121 Commentaires)
6.4
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

250 € EUR en 2 jours
(87 Commentaires)
5.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

50 € EUR en 3 jours
(100 Commentaires)
6.1
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

34 € EUR en 0 jours
(202 Commentaires)
6.1
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

60 € EUR en 3 jours
(95 Commentaires)
6.1
88 € EUR en 3 jours
(57 Commentaires)
5.5
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

100 € EUR en 10 jours
(21 Commentaires)
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 Plus

34 € EUR en 2 jours
(68 Commentaires)
5.7
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

100 € EUR en 1 jour
(60 Commentaires)
5.4
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

50 € EUR en 1 jour
(36 Commentaires)
4.9
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

30 € EUR en 3 jours
(37 Commentaires)
4.9
abdolah2014

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

111 € EUR en 3 jours
(30 Commentaires)
5.1
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 Plus

263 € EUR en 3 jours
(13 Commentaires)
5.1