Find Jobs
Hire Freelancers

Do some Excel Work

$10-30 USD

Cerrado
Publicado hace casi 9 años

$10-30 USD

Pagado a la entrega
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 del proyecto: 7805776

Información sobre el proyecto

26 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
26 freelancers están ofertando un promedio de $24 USD por este trabajo
Avatar del usuario
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 en 3 días
4,9 (116 comentarios)
6,0
6,0
Avatar del usuario
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 en 3 días
5,0 (51 comentarios)
5,4
5,4
Avatar del usuario
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 en 0 día
4,9 (10 comentarios)
4,3
4,3
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
4,9 (18 comentarios)
4,1
4,1
Avatar del usuario
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 en 2 días
4,9 (20 comentarios)
4,1
4,1
Avatar del usuario
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 en 2 días
4,8 (18 comentarios)
3,8
3,8
Avatar del usuario
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 en 1 día
4,9 (6 comentarios)
3,5
3,5
Avatar del usuario
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 en 1 día
4,9 (11 comentarios)
3,3
3,3
Avatar del usuario
Dear Employer I can accomplish the job for you. Kindly contact me for further details. Thanks and regards Roy
$25 USD en 2 días
5,0 (18 comentarios)
3,2
3,2
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
3,0
3,0
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,3
1,3
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
1,4
1,4
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
0,4
0,4
Avatar del usuario
A proposal has not yet been provided
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$30 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de THAILAND
Chiang Mai, Thailand
0,0
0
Forma de pago verificada
Miembro desde feb 14, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.