Find Jobs
Hire Freelancers

macro for excel file

€8-30 EUR

Terminado
Publicado hace alrededor de 4 años

€8-30 EUR

Pagado a la entrega
I have more than 10 identical excel files. Each sheet of this file is protected with the same password “1234”. These files have a mistake in the formulas. I create a correct file with correct formulas with the name “correct file”. I will send this file to each user in order to correct their excel files. Each user will open on his pc the correct file and the file that we want to correct. In the correct file I want a button in the sheet “data”. Each user will copy this button to his excel file in order to copy the VBA code. With the press of this button I want: 1. Go to sheet “salary”, unprotected the sheet with password “1234” copy the formulas from the correct file B5:l18 and B18:L18. Then to protect the file with “1234”. 2. Go to sheet “SI” unprotected the sheet with password “1234” copy the formulas from the correct file B5:lL5, B8:L8, B12:L12 and B18:L18. Then to protect the file with “1234”. 3. Go to sheet “income tax” unprotected the sheet with password “1234” copy the formulas from the correct file B6:l6 and B13:L13. Then to protect the file with “1234”. 4. Go to sheet “data trans” unprotected the sheet with password “1234” copy all (formulas) from the correct file to the current file. Then to protect the file with “1234”. 5. Go to sheet “certificate” unprotected the sheet with password “1234” copy all (formulas) from the correct file to the current file. Then to protect the file with “1234”.
ID del proyecto: 24921389

Información sobre el proyecto

17 propuestas
Proyecto remoto
Activo hace 4 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
Adjudicado a:
Avatar del usuario
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you 30€* and can deliver within three days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed nearly 400 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
€30 EUR en 3 días
4,9 (246 comentarios)
7,5
7,5
17 freelancers están ofertando un promedio de €23 EUR por este trabajo
Avatar del usuario
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 ensure you will be happy after hiring me. Kindly contact me. Roy
€40 EUR en 1 día
4,9 (380 comentarios)
7,0
7,0
Avatar del usuario
Hello, I would like to work on your project. I have a great experience using excel macros / VBA, data formatting and data manipulation in excel. I have reviewed the project requirements and your files and I am confident I can finish the needed macro within 1 day. It will have 3 command buttons, 1th to select the source folder, 2th to select the destination folder (for the corrected files) and 3rd command button to launch the macro which will do the required tasks, you can have as many files you need to be corrected in the source folder. Waiting for response and of course, I am open to any other ideas if you have. Regards.
€30 EUR en 1 día
5,0 (129 comentarios)
6,5
6,5
Avatar del usuario
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel developer currently at the post of Forum Expert at www.excelforum.com. I would like to provide my services for this project. A better alternative to what you are trying to achieve is that we ask the user to import the previous file and then the code will import the data from the previous file into the new correct template, instead of fixing the formulas in the previous file which is not very user friendly and more prone to errors. I can help setup a script for you which would be able to accomplish the same. I look forward to a positive and prompt response from your end. Regards Sourabh
€30 EUR en 1 día
5,0 (139 comentarios)
6,0
6,0
Avatar del usuario
hello sir i understand the work in excel you want to be done .... i will do that in few hours from now i am an expert in excel and have done many excel projects in past with excellent ratings so far open a chat session to discuss thank you hope to hear from you
€15 EUR en 1 día
4,9 (74 comentarios)
5,2
5,2
Avatar del usuario
Hi, I went thru the description and the files attached This can be started by today Contact me and I will complete in 1 day I look forward to hearing from you Thanks Regards Thushara
€30 EUR en 1 día
5,0 (25 comentarios)
4,3
4,3
Avatar del usuario
Understood You want to make an automation process ? ok we can use excel api to unlock excel sheet and do the changes you asked above Can you initiate a quick chat please. Siva
€25 EUR en 2 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
I have keen interest in delivering exceptional service in terms of excellence and accuracy in your anticipated job.
€19 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
HII, I’M AN ENTHUSIASTIC DATA ENTRY SPECIALIST. I CAN INPUT DATA WITH ACCURACY IN REASONABLE DELIVERY TIME. I CAN DO ANY KIND OF DATA ENTRY MAY BE IT IS PDF TO WORD/EXCEL OR COLLECTION OF DATA FROM ANY SITE FOLLOWED BY FILLING THE SPREADSHEET. I CAN ALSO TRANSFER DATA FROM ONE WEBSITE TO ANOTHER AS PER YOUR INSTRUCTIONS. I AM A DEDICATED AND FULL-TIME FREELANCING IS MY PROFESSION. AWARD ME THIS PROJECT SO THAT I CAN IMMEDIATELY START TO WORK.
€8 EUR en 14 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I'm an experienced candidate with good typing and data entry skills. I assure you to deliver the work before time with 100% accuracy. I am expert in- * Pdf conversion * Excel conversion * HTML * Java etc.
€19 EUR en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have 4yrs of experience in creating excel macros
€24 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello client! I have huge experience in Ms Exel macro running. I know very well to create a new file to you as similar with macro coding and formulas also customized as you want. Please further discuss in chat open chat and discuss more
€19 EUR en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de CYPRUS
Paralimni, Cyprus
5,0
1
Forma de pago verificada
Miembro desde abr 6, 2020

Verificación del cliente

Otros trabajos de este cliente

macro to create txt files
€8-30 EUR
¡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.