Find Jobs
Hire Freelancers

Excel macro

$30-250 AUD

Закрито
Опублікований over 6 years ago

$30-250 AUD

Оплачується при отриманні
I have some work, in an Excel spreadsheet. I have designed an excel spreadsheet with 300 employees covering 7 days on one tab. There are multiple columns I need to fill in ie job description/hours worked etc (about 10 columns for each day per employee). Can you run a macro that only shows employees that has data entered (note: the first 2 out of the 10 columns of each of the 7 days are always filled in) Keeping in mind this is duplicated over 7 days. So it needs to show the employees with any data (1-7 days). If not, can you run a macro that generates a new tab that shows the lines (employees) with data entered in columns (x7) category called total hours? And can you highlight if a column named job description or a column named job is blank when the same line shows data in another column?
ID проекту: 16210854

Про проект

36 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
36 фрілансерів(-и) готові виконати цю роботу у середньому за $107 AUD
Аватарка користувача
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.
$100 AUD за 3 дні(-в)
4,9 (298 відгуки(-ів))
7,2
7,2
Аватарка користувача
Hi there. My name's Paris. I'm an experienced Excel developer. I've developed many complex macros in the past. What you describe is something I can do easily and I ensure you the macro I will create will automate your process and make your life easier. Among other things, when the macro will be executed, the blank cells will be highlighted. The macro will be initiated by pressing a single button. I'm looking forward to hearing from you. Regards
$90 AUD за 1 день
4,9 (196 відгуки(-ів))
7,2
7,2
Аватарка користувача
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I can help you in this project. Roy
$120 AUD за 2 дні(-в)
4,9 (310 відгуки(-ів))
6,8
6,8
Аватарка користувача
Greetings! It is possible to achieve your first objective - only showing employees that has data entered. Also, it is possible to highlight column based on data in another column. I understand your requirements and can do the needful. Please share the file. Being a full time freelancer working exclusively on Excel based projects, I work on developing macros every single day. I have 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 18 MONTHS , spent at least 250 HOURS on automation in Excel every month. If awarded, I guarantee defect free solution. Have a Great Weekend! Srinivasan
$60 AUD за 3 дні(-в)
5,0 (176 відгуки(-ів))
6,7
6,7
Аватарка користувача
Hi there - I would love to take a look at your sheet, it sounds like you may not need a macro but some advanced filtering (possibly with some formulae in there to help out). However if you wish the employees without data to be moved this can definitely be done with a macro. The highlights are achievable as well using conditional formatting; but from reading your job it sounds like it could work better for you instead if the highlighted cells auto-populated in this case. About me: I am an Australian business analyst with 15 years professional experience developing automation and data processing solutions using Excel and VBA (macros). I am passionate about Excel, I love using a tool which most people can access to build solutions which save busy people time! I build easy-to-use, stable, innovative solutions, and I would love to take a look at your sheet.
$72 AUD за 2 дні(-в)
5,0 (28 відгуки(-ів))
5,1
5,1
Аватарка користувача
Hi, I can help on this . Please discuss now. You can check my profile for more review and feedback. Thank you!
$200 AUD за 3 дні(-в)
4,9 (32 відгуки(-ів))
4,9
4,9
Аватарка користувача
Hello, here is your excel expert. I will fill the details correctly, within your budget ad time. Kindly contact
$155 AUD за 3 дні(-в)
4,8 (9 відгуки(-ів))
4,1
4,1
Аватарка користувача
Hello Please see answers below Can you run a macro that only shows employees that has data entered (note: the first 2 out of the 10 columns of each of the 7 days are always filled in) Keeping in mind this is duplicated over 7 days. So it needs to show the employees with any data (1-7 days). YES If not, can you run a macro that generates a new tab that shows the lines (employees) with data entered in columns (x7) category called total hours? POSSIBLE AS WELL And can you highlight if a column named job description or a column named job is blank when the same line shows data in another column? YES
$155 AUD за 3 дні(-в)
5,0 (9 відгуки(-ів))
4,0
4,0
Аватарка користувача
My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.
$30 AUD за 2 дні(-в)
4,4 (46 відгуки(-ів))
4,6
4,6
Аватарка користувача
Hello, I can change cell colours, filter out or remove rows, relocate rows which need data filling out etc. For any of the members which hit specified criteria. So if you want to highlight rows where some data is missing, or just the missing cells, and filter out complete rows etc. I can do that. The macro would be created in VBA and then executed through a button I would add. Please let me know if you have any further questions. Thanks Arran
$100 AUD за 2 дні(-в)
5,0 (12 відгуки(-ів))
4,1
4,1
Аватарка користувача
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.
$118 AUD за 3 дні(-в)
4,7 (14 відгуки(-ів))
4,0
4,0
Аватарка користувача
Hey, I am a qualified Chartered Accountant with more than 10 years of experience in accounting and finance. My profession involves me to work and play around with figures and calculations and I love working with Excel. Having detailed knowledge and expertise in Excel I have a strong command over formals, pivots, graphs, formatting etc. and can bring out a perfect solution for someone genuinely looking for results. There is no fee for discussing anything, just give me a buzz on Chat and we can go around the things. If both agreed on, we can sign a contract and have a long-term professional relationship. Cheers.
$222 AUD за 3 дні(-в)
5,0 (5 відгуки(-ів))
3,3
3,3
Аватарка користувача
Hi This is quite simple and straightforward. I already have the solution building in my head. Can you send me an example of the data in your spreadsheet so we can discuss further? I do believe that I should be able to do what you request in a day or less. Kind Regards John
$70 AUD за 3 дні(-в)
5,0 (13 відгуки(-ів))
3,2
3,2
Аватарка користувача
Hello, i am interested in your project. I can help you showing the only data entry employees with whatever method you need. I will need some more details over chat. waiting to hear from you, thank you.
$155 AUD за 3 дні(-в)
5,0 (3 відгуки(-ів))
3,3
3,3
Аватарка користувача
Hello, I am interested in your offer and I am ready to cooperate. I have experience in writing macros VBA for Excel. It's hard for me to answer your questions without seeing the Excel spreadsheet. Send the spreadsheet I will look.
$55 AUD за 3 дні(-в)
4,7 (6 відгуки(-ів))
2,9
2,9
Аватарка користувача
Excel expert here for you. Since I'm in Australia we can easily communicate if any problems need to be sorted out.
$100 AUD за 3 дні(-в)
4,6 (5 відгуки(-ів))
2,6
2,6
Аватарка користувача
I have knowledge about macro and i can make this job happen. We can have call for further discusuion to understand more about nature of job.
$155 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Working with Excel to create useful easy tools for Data Entry/Analysis/Visualization reports , developing tools using Formulas , tables , charts , Macro and VBA.
$155 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I think this is a tempting offer that can not be missed I hope that the offer will impress you I am very happy to serve you
$155 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I can do this, need your email id or skype id to discuss the requirement
$60 AUD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор AUSTRALIA
Australia
0,0
0
На сайті з лют. 2, 2018

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.