Find Jobs
Hire Freelancers

Do some Excel Work

$10-30 USD

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

$10-30 USD

Оплачується при отриманні
Please Help! Stuck on Formulas for keep station plan up to date Hi everyone. I'm a newly registered member. Hope someone 'out there' can help me with this task I'm completely overstrained... I have 25 Daily tasks in a column, every task comes with 8 values, there is a dropdown list on the top of every task (dropdown list Station 1 to 25 . After choosing the Station for example A6 I would need the following 7 cells include the Station number moved to another place in the same sheet. I would need this action to create an Floorplan to keep visual on track with the daily progress. I have tried several formulas, but I cannot make this work. I would be really grateful for anyones help on this, as I have spent hours and hours on this, and I am just banging my head on the wall! Many thanks, Patrick
ID проекту: 7805776

Про проект

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

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

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

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
26 фрілансерів(-и) готові виконати цю роботу у середньому за $24 USD
Аватарка користувача
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 235 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD за 3 дні(-в)
4,9 (116 відгуки(-ів))
6,0
6,0
Аватарка користувача
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 regards
$30 USD за 3 дні(-в)
5,0 (51 відгуки(-ів))
5,4
5,4
Аватарка користувача
Hi My name is Dan. I am an expert in excel and I can give you the formula immediately upon awarding me the project. I have the formula ready. Please message me so that we can proceed. Thanks ! Regards Dan
$30 USD за 0 день
4,9 (10 відгуки(-ів))
4,3
4,3
Аватарка користувача
A proposal has not yet been provided
$25 USD за 1 день
4,9 (18 відгуки(-ів))
4,1
4,1
Аватарка користувача
Hello, Thank you for explaining in details your requirements. I have gone through your description and the example file and I would like to place a bid. My approach shall be to write VBA scripts (not Excel Formulas) to perform what you need. All the codes shall be placed in the sheet_change event, so that there shall not be any need to run the macro manually. whenever a change occurs in the dropdown boxes, the related info shall be carried up to the proper table. I have completed several VBA jobs successfully (you can view that on my profile) - so you can be sure I shall be able to do the job for you. I have 1 question though. It is, when two dropdown boxes contain the same station name, whichone shall I chose to take the info from. For example, say cell A36 already has the station-value "A6" chosen. now if the user choses "A6" in the cell A4, what shall happen then? shall the table for station A6 contain the values from cell A5 to A11 , or shall the table contain values from A37 to A 43? I hope I could make myself clear. Please let me know if you would like to discuss further before awarding the job to anyone. With thanks & best regards Raad
$27 USD за 2 дні(-в)
4,9 (20 відгуки(-ів))
4,1
4,1
Аватарка користувача
I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting. I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors. I'm looking forward to serve you, on your available task.
$20 USD за 2 дні(-в)
4,8 (18 відгуки(-ів))
3,8
3,8
Аватарка користувача
More than 11 years of experience in Banking/finance, Business Analysis, Copy Typing, Web Research, Scrapping, data compilation, social media and Data analysis. I am an expert in MS office, which includes Dash Board preparation, Mail merge, Formulae, Macros (VBA), Charts, Template creation, Pivot, etc., I am very quick in completing tasks using my keyboard, shortcuts and multitasking skills.
$10 USD за 1 день
4,9 (6 відгуки(-ів))
3,5
3,5
Аватарка користувача
Hello sir, I am the expert in Copy typing, data entry, data processing, Ms Excel. MS work, This work is very easy for me, I have 12 year experience like this type of work. I think I am the perfect person for your project sir please award me. I am waiting for your reply. Thank you.
$15 USD за 1 день
4,9 (11 відгуки(-ів))
3,3
3,3
Аватарка користувача
Dear Employer I can accomplish the job for you. Kindly contact me for further details. Thanks and regards Roy
$25 USD за 2 дні(-в)
5,0 (18 відгуки(-ів))
3,2
3,2
Аватарка користувача
Hi Patrick, Please don't break your head when I'm there. You can do that with VBA. Please contact me for further details of your project Thanks
$25 USD за 1 день
5,0 (3 відгуки(-ів))
3,0
3,0
Аватарка користувача
Hi, I am experienced excel and vba user, and I would be glad to work on this project. I am sure that your requested tasks can be solve inserting some vba code in excel file. I will need your guidance, in some questions. In sample file there are six tables with green headers: A1-A6. Must be created another 19 tables to reach at total numbers of 25. Right? or wrong? When you change dropdown menu to A1 (for example) the values (7 items) under A1 will be copied in cells J7-J13. I want to ask if it is not better to copy formula in J7-J13 that takes value from A4-A11. like in cell J7 put the formula =A4, in J8..=A5 so on. If we can put formula they will automatically update values from column A, if not, must be control with code if in column A will be change some values to updating in Column J. We can fix details in Message box.
$20 USD за 1 день
5,0 (2 відгуки(-ів))
1,3
1,3
Аватарка користувача
i have found out the solution and can give you in 1 hour time. kindly award me and get your work done, I have awesome knowledge of excel and formulas Thanks
$35 USD за 1 день
5,0 (2 відгуки(-ів))
1,4
1,4
Аватарка користувача
Dear Hiring Manager I have relevant sort of expertise and interested to give my highest effort in making the paper. I have ideas on referencing systems and will ensure the highest standard To satisfy you. Lets discuss pls.
$20 USD за 1 день
5,0 (2 відгуки(-ів))
0,4
0,4
Аватарка користувача
A proposal has not yet been provided
$15 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hey Patrick, I have sound knowledge of excel formulas. Assign me this task and I'll fix it in less than an hour. It would be helpful if you give me the sample sheet so that I can work out the formula on the same. Thanks, Tarun
$15 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
i am master in IT so this task is easy for me. I am just a new comer on this site and looking for some work to start my career as a freelancer. Grant me this project and consider it done.
$20 USD за 1 день
5,0 (1 відгук)
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$30 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I am familiar with excel and I have done what you are asking for before. I am able to do the job you are offering. I hope that my work will satisfy your needs and what you are looking for. Consider it done.
$12 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Thank you for providing this example. i have read this description very seriously. i tried a formula and its really works as you described. i would like to know further information about this project. do you want to send this respective drop down data to anywhere else in this sheet? thank you. i would appreciate if you would reply. any further query, you are always welcome. thanks.
$20 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор THAILAND
Chiang Mai, Thailand
0,0
0
Спосіб оплати верифіковано
На сайті з лют. 14, 2013

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

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