Find Jobs
Hire Freelancers

Excel VBA code for updating workbook from external sheet with different date structure

£10-20 GBP

En curso
Publicado hace alrededor de 5 años

£10-20 GBP

Pagado a la entrega
I have the following situation: I have 2 excel workbooks each contains 1 sheet, holiday trackers. I am trying to update holiday_tracker2 (workbook2) with data from holiday_tracker1 (workbook1). Tricky situation is that the date structure in holiday_tracker2 is different then in holiday_tracker1. In holiday_tracker2 H=8h, HD=4h In holiday_tracker1 there are values 8, 40, 24 and 4 How can I automatically update holiday_tracker2 with this values but to be assigned to the same format H,HD? I need VBA code which will work on original files.
ID del proyecto: 18719210

Información sobre el proyecto

28 propuestas
Proyecto remoto
Activo hace 5 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
28 freelancers están ofertando un promedio de £20 GBP por este trabajo
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
£20 GBP en 3 días
5,0 (321 comentarios)
7,4
7,4
Avatar del usuario
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
£23 GBP en 1 día
5,0 (182 comentarios)
7,0
7,0
Avatar del usuario
Greetings! Just to confirm, a value of 40 in holiday_tracker1 - does it correspond to 5H in holiday_tracker2? If it is OK with you, I can change the format of the table such that data is much easier to track (following the same H/HD and actual value system). Have a Great Day! Srinivasan Krishnamoorthi
£20 GBP en 1 día
5,0 (225 comentarios)
7,0
7,0
Avatar del usuario
Hi, I am an expert in Microsoft Excel including VBA or Macros development. I can provide and develope you a macros which will put the data from external sheet in required format. Looking forward to working with you. Kind Regards Gopal
£15 GBP en 2 días
5,0 (29 comentarios)
6,7
6,7
Avatar del usuario
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
£19 GBP en 1 día
5,0 (60 comentarios)
6,5
6,5
Avatar del usuario
Hello, I am Excel and VBA expert. One question - what value should be in workbook2 if in worlbook1 is 24 or 40? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan
£23 GBP en 3 días
5,0 (94 comentarios)
6,1
6,1
Avatar del usuario
IS THAT A DIFFERENT WORKBOOK (IN ORIGINAL FILES) OR ELSE SAME WORKBOOK WITH TWO SHEETS.. Because if different WORKBOOK then the workbook name will be used to refer.. I can show you the working version of this formula.. Please ping me if you are interested with my prposal and thank you..
£50 GBP en 1 día
4,9 (29 comentarios)
5,1
5,1
Avatar del usuario
Hi Good Day! A serious freelancer here! I can help you to complete this project in 1-2 days. I have a lots of available time for this work project. Please accept me to this job. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
£20 GBP en 2 días
4,7 (79 comentarios)
5,6
5,6
Avatar del usuario
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
£18 GBP en 1 día
4,9 (30 comentarios)
5,1
5,1
Avatar del usuario
"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your current project and able to provide accurate and quick service. You know! I’m efficient and experienced data entry worker. If you consider me for this job, I will try my level best to complete your project within our committed deadline. I look forward to hearing from you about the project. Regards"
£20 GBP en 1 día
5,0 (18 comentarios)
4,3
4,3
Avatar del usuario
Send sheet and get your work done ASAP. I will set to work
£13 GBP en 1 día
5,0 (8 comentarios)
3,6
3,6
Avatar del usuario
Hi. It's Done! If you want I send to you what I did without cost! If is that what you want, you pay me. Thank you.
£13 GBP en 0 día
5,0 (3 comentarios)
2,1
2,1
Avatar del usuario
hi, we already examine your worksheets 1 and 2 for holiday tracker 1 and 2 the raw data is coming from holiday tracker 1, with the date, name and the data itself. we understand that you want to transfer the data from holiday tracker 1 to holiday tracker 2 base on the name and the date also and it has to precisely input into the holiday tracker 2 table. we can make the macro for you, we need more info regarding about the holiday tracker 1, in the description, you said H=Full day, which mean 8 hours and HD = Half day which mean 4 hours how about the number in holiday tracker 1, that state 8, 40, 24 and 4, for number 8 we assume it is full day ??? and number 4 it is HD and the data will be input into tracker 2 matching the name and the date? then the next question is what 24 and 40 mean? if we assume from your description 24/8 will be 3 Full days starting from the date in tracker 1 or 24/4 which mean 6 days from the date and for number 40 it is either 40/8 or 40/4 and the end result will be a mark of holiday number in tracker 2 starting from the date in tracker 1 is this what you need????? if not, please do inform us exactly you need and we can start to build the macros our working estimation for matching the data and input into the sheet around 2 days for further information, you can contact our phone 08.13-82.82-96.98 thank you please also check our other project in our youtube channel "EXCEL DAHSYAT" we have plenty of work has been done
£18 GBP en 1 día
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
This would be a relatively simple project to complete, I would be able to complete it within the next day or two
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
expert VBA coder, has built production level applications, can showcase work done earlier
£23 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can provide you the work in given time
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I will provide you an accurate and easy to handle file which you can use forever. Relevant Skills and Experience We may use vlookup formulas or else I will write a vb code
£15 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
My Greetings, This is really a too easy task, I will do the Bid just bcuz its a protocol, but well, let's rock' n roll. See ya :)
£10 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi.. I have 8+ years of experience in Excel. I have been into robotics team and can automate all excel related reports, dashboards. We can create a logic and based on it this can be updated using formulas. If needed we can automate as well. Please let me know to discuss and proceed further. Happy to help you.
£18 GBP en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have expertise in VBA in Excl, Access and Outlook. In fact I used o develop in Visual Basic, ASP, PHP, VBA and macros. I can provide a quality solution and also see if I can improve anything on your excel sheets. Can you please let me know the conversion factory how does 8, 40, 24 and 4 translate to data from Workbook 1? Be rest assured your job will be done with quality and before time, Request to please confirm with me on scope of work and final rates before placing the order.
£19 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
5,0
1
Miembro desde mar 18, 2018

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.