Find Jobs
Hire Freelancers

macro for excel file

€8-30 EUR

Suoritettu
Julkaistu noin 4 vuotta sitten

€8-30 EUR

Maksettu toimituksen yhteydessä
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”.
Projektin tunnus (ID): 24921389

Tietoa projektista

17 ehdotukset
Etäprojekti
Aktiivinen 4 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
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 3 päivässä
4,9 (246 arvostelua)
7,5
7,5
17 freelancerit tarjoavat keskimäärin €23 EUR tätä projektia
Käyttäjän avatar
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 1 päivässä
4,9 (380 arvostelua)
7,0
7,0
Käyttäjän avatar
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 1 päivässä
5,0 (129 arvostelua)
6,5
6,5
Käyttäjän avatar
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 1 päivässä
5,0 (139 arvostelua)
6,0
6,0
Käyttäjän avatar
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 1 päivässä
4,9 (74 arvostelua)
5,2
5,2
Käyttäjän avatar
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 1 päivässä
5,0 (25 arvostelua)
4,3
4,3
Käyttäjän avatar
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 2 päivässä
5,0 (2 arvostelua)
1,8
1,8
Käyttäjän avatar
I have keen interest in delivering exceptional service in terms of excellence and accuracy in your anticipated job.
€19 EUR 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 14 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I have 4yrs of experience in creating excel macros
€24 EUR 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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 1 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan CYPRUS lippu
Paralimni, Cyprus
5,0
1
Maksutapa vahvistettu
Liittynyt huhtik. 6, 2020

Asiakkaan vahvistus

Muita töitä tältä asiakkaalta

macro to create txt files
€8-30 EUR
Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.