Find Jobs
Hire Freelancers

Do some Excel Work

$12-30 SGD

Geschlossen
Veröffentlicht vor etwa 7 Jahren

$12-30 SGD

Bezahlt bei Lieferung
Hi guys, I need to make an excel for some data entry and i am having some difficulty with my macros. Would appreciate your assistance. I currently have a excel sheet of column A to G and rows 1 to [login to view URL] excel sheet has 6 headers from B to G and numbered rows from row 2 to 101. I have protected the sheet to only allow cell entries from cells B2 to G101. I intend to include a 'finish' button at G102 for the data entry personnel to press once they have reached the end of the excel sheet or finished their data entry process. It is essential that the excel sheet has only 100 rows worth of data I currently need 4 macros to work one after another when i press the 'finish' button 1) Remove all numerics from column E 2) If cells of the same row in either column D and E contain partial/identical text to column B, then the cells in both column D and E should be blanked out. (preferably to loop each row) 3) The workbook is automatically saved into a destination file of my choosing and the first workbook is saved as a running number e.g. 'workbook 1' and the subsequent ones are 'workbook 2', 'workbook 3' etc. 4) A new workbook is created titled 'workbook 2' and opened with the original headers and row numbers already in place. (assuming someone just finished the first workbook) The macros should run in the order stated above. Thank you, Mark Lim
Projekt-ID: 12809043

Über das Projekt

12 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
12 Freelancer bieten im Durchschnitt $32 SGD für diesen Auftrag
Avatar des Nutzers
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 SGD in 1 Tag
4,9 (160 Bewertungen)
6,4
6,4
Avatar des Nutzers
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$30 SGD in 1 Tag
5,0 (86 Bewertungen)
5,8
5,8
Avatar des Nutzers
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$50 SGD in 1 Tag
4,8 (97 Bewertungen)
6,1
6,1
Avatar des Nutzers
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$30 SGD in 1 Tag
5,0 (36 Bewertungen)
4,9
4,9
Avatar des Nutzers
Hi, I am Excel expert and VBA programmer send me your files and I will help you Thanks & Regards will wait for your response
$30 SGD in 1 Tag
4,8 (23 Bewertungen)
4,8
4,8
Avatar des Nutzers
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 2 years of experience. I have successfully completed few projects for US clients which involved web scraping, web research,internet research and data entry. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) High quality data 4) Best tools and techniques used for the completion of tasks Looking forward to hear from you. Regards
$17 SGD in 2 Tagen
4,9 (18 Bewertungen)
3,6
3,6
Avatar des Nutzers
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
$30 SGD in 1 Tag
4,8 (14 Bewertungen)
3,8
3,8
Avatar des Nutzers
"Rate and duration will be fixed on discussion" Greetings, I got interested in your project and would be glad to discuss all the issues with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile and portfolio. I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Thank you Bellal Hossain
$31 SGD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
My expertise as an Inventory Clerk for one of the most prestigious computer companies in the Philippines for almost 4 years will be a great factor for me to be able to perform my job well. I also worked abroad (Dubai, UAE) wherein I was able to showcase my expertise in various Microsoft Office applications like MS Word, Excel, Powerpoint, Turbo C, Java,PHP and HTML is also my advantage. I also have a short course degree in Diploma in Office Management that served as my training ground for various office and data entry jobs. I am currently taking up Bachelor of Science in Information Technology that helps to continually improve my skills in information technology and alike. My skills when it comes to Microsoft Office apps will be: Computer Proficiency: (MS Excel, MS Word, MS Application, Web Browsing, MS Powerpoint,Turbo C, Java and HTML) Typing Skills: 45wpm I am looking for a possible working opportunity with you.
$27 SGD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Dear sir , As an data entry specialist , I am very interested in  your job post. I am expert in Microsoft Word and Excel and also a detail-oriented person. My four years in college and  currently studying as an student in university of colombo, i am well experianced in stats , excel and in survey. plus my work experience as shown in my profile have helped me develop mastery in Word and Excel. As proof, I got high marks in both tests in oDesk and I also received positive feedback from my previous employers regarding Word- and Excel-related projects. I am looking forward to discussing with you about this job post. Please feel free to contact me through skype or email. I am available online 12 hours a day. Respectfully, Thisara
$31 SGD in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von SINGAPORE
Singapore, Singapore
5,0
1
Zahlungsmethode verifiziert
Mitglied seit Jan. 17, 2017

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.