Excel- Macro - Loop through list and check through criteria
€30-250 EUR
Оплачується при отриманні
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!
ID Проекту: #12634806
Про проект
71 фрілансерів(-и) готові виконати цю роботу у середньому за €91
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.
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 Більше
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 Більше
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.
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
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 Більше
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 Більше
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 Більше
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 Більше
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 Більше
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
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
HI I am an excel-vba Expert and I can finish your project so fast start the chat to discuss more .........................................................................................