Find Jobs
Hire Freelancers

Make an excel invoice template that can be changed with a password protected macro or similar

$30-250 USD

Completato
Pubblicato più di 6 anni fa

$30-250 USD

Pagato al completamento
OK first up I should tell you I always delete all bids that don't start with my keyword because I find the auto bidding on here so offensive. So to prove you have read this project brief, you must start your bid with the word DUSTER or I will delete it. My business works by getting contractors to invoice me in their details - name, company name, address, etc, hours worked, hourly rate, etc, and bank details to pay them at. I then invoice direct to my client and have to put on my invoice all the same details, but at higher rates, different bank to pay, my company details, etc. Sadly we often make mistakes when copying across, so I would prefer it if there was a Macro or similar to just auto replace all the details that need replacing each time, namely; Replace the contractors details with my company details Replace the contractor's hourly rate with the charge out hourly rates replace the bank details of the contractor with our bank details Replace the contractors invoice number with our invoice number There are some other calculations the templates make that have to stay in, such as how the To help explain this, I have attached 3 excel spreadsheets with apt names; 2 are examples of the templates as per how contractors might fill them out 3rd is an example of 1 of the templates after the macro is run, so showing my company details and charge out rates. We do not want the contractors to be able to run this macro, it is for us to run I do not want the contractors to see what I charge them out at. Of course MAcro is only 1 solution, if you have a different way of doing it then fine, its the result I am interested in. Please see the attached, let me know your quote inc the timeline am hoping to get this pack today please. A reminder to prove you have read this project brief, you must start your bid with the word DUSTER or I will delete it.
Rif. progetto: 15441689

Info sul progetto

25 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
DUSTER Will be done You mentioned as attached 3 file, but only 1 file is there. Secondly, is this template is common for all(cell and rows wont change) Relevant Skills and Experience Excel Proposed Milestones $80 USD - Duster Let me know when you want
$80 USD in 3 giorni
5,0 (17 valutazioni)
3,7
3,7
25 freelance hanno fatto un'offerta media di $132 USD
Avatar dell'utente
DUSTER. Hi, I ll code a macro to copy and generate your invoice based on their data. I ll do it in a hidden sheets with pasword protection. Thanks Expérience et Compétences appropriées Excel/VBA Étapes proposées $100 USD - m
$100 USD in 2 giorni
4,9 (277 valutazioni)
7,7
7,7
Avatar dell'utente
DUSTER Hi there - My name's Paris. I can develop the macro you require. I am going to add a single button that once clicked it will ask the user for a password and if right the macro will run. Relevant Skills and Experience I have a huge experience in developing macros for Excel spreadsheets for about a decade. Proposed Milestones $95 USD - When you are happy with the spreadsheet I will send to you. When can I start?
$95 USD in 1 giorno
4,9 (229 valutazioni)
7,4
7,4
Avatar dell'utente
Hello. So you need something like an dynamic invoice template to easily create invoices, right? I can build an Excel template for you using Excel and VBA (if necessary) Contant me to discuss further. Relevant Skills and Experience Excel, VBA, Data Processing, Dashboard design. I will create the Excel template which you will be able to update easily in the future without any assistance. Proposed Milestones $315 USD - job done
$315 USD in 7 giorni
5,0 (142 valutazioni)
7,1
7,1
Avatar dell'utente
DUSTER. Reviewed new attachments and revised bid. I can write a macro that runs only if a password is entered correctly so that the contractors do not have access. Note: In the after macro file, though comment says Rate changed to 30GBP per hour, it has not been changed. Also, it is col K where rate is available and not col J as mentioned in note. I understand what needs to be done and can do the needful. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 15 MONTHS , spent at least 250 HOURS on automation in Excel every month. Proposed Milestones $80 USD - Macro for file conversion
$60 USD in 1 giorno
5,0 (190 valutazioni)
6,8
6,8
Avatar dell'utente
DUSTER, Hi there, I could find only 1 attachment. Please send the other attachments to evaluate. Relevant Skills and Experience I am an excel/word/outlook VBA automation professional having 7+ years of experience Thanks Aman Proposed Milestones $244 USD - 1
$244 USD in 3 giorni
4,9 (161 valutazioni)
6,4
6,4
Avatar dell'utente
DUSTER I would like to present myself as a candidate for your consideration. Relevant Skills and Experience Excel(Advanced) VBA Proposed Milestones $155 USD - This task will be completed within schedule
$155 USD in 3 giorni
4,9 (41 valutazioni)
5,7
5,7
Avatar dell'utente
Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. I will complete this task with your timeline and budget. Relevant Skills and Experience Web searching, Data Entry, Excel, Microsoft Excel, Word, Project Management, Type, Product Listing, Virtual Assistant Proposed Milestones $30 USD - Our Client's Satisfaction is our Identity.
$30 USD in 1 giorno
4,9 (80 valutazioni)
5,1
5,1
Avatar dell'utente
DUSTER I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start Stay tuned, I'm still working on this proposal.
$250 USD in 3 giorni
4,8 (90 valutazioni)
5,3
5,3
Avatar dell'utente
DUSTER is made by Dacia :) Hi, I’ve read your proposal and I find it very interesting since I’ve already automated a similar invoicing workflow for US customers. I would love to get in contact with you and create this useful project. There’s no need to start listing my skills here because my portfolio show a lot of examples. Cheers, Marius
$90 USD in 2 giorni
5,0 (27 valutazioni)
4,4
4,4
Avatar dell'utente
Hi, I can do this project accurately and deliver in few hours...
$30 USD in 3 giorni
4,9 (9 valutazioni)
3,0
3,0
Avatar dell'utente
DUSTER Hello there! I work at a university and I create macros for them. I just need some examples, some active communication from you and I'm sure we'll get this project running in no-time Relevant Skills and Experience I create macros and such for my workplace, which I use to automate tasks Proposed Milestones $111 USD - When you are satisfied with my work and it's fully finished Additional Services Offered $10 USD - If you need any changes done at a later date and it's harder to do (otherwise it's free) Can you contact me for further details? Also note that I'll only start working if you approve me
$111 USD in 3 giorni
5,0 (2 valutazioni)
2,8
2,8
Avatar dell'utente
Hi, I read though your descriptions and I'm able to do this job. I have more then 3 years experience about this. So i will complete this project 100% properly. Thanks
$150 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Duster. hey there, my majoring is in office system management. I am interested in this job as I have a proficiency skill in this area. Relevant Skills and Experience I have experiences almost 7 years in microsoft excel. Proposed Milestones $50 USD - Deposit $105 USD - Full Document Do you have any sample for this job ?
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
DUSTER i know excel very well It's my every day use will help you
$30 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
A proposal has not yet been provided
$122 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
DUSTER I am a sales & marketing associate with experience in using excel daily for different types of projects. I can get started on this ASAP and submit it within 5 hours or less. Relevant Skills and Experience I have done admin, sales, and marketing tasks. Proposed Milestones $133 USD - Document formatting
$133 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
DUSTER :) If I'm right, you want to seamless change the details of the contractor on a page and it'd be reflected automatically in another page. Oh the attachment only has one sheet.. Relevant Skills and Experience Excel, Reporting, Analysis Proposed Milestones $100 USD - Create data page $100 USD - Create report page Additional Services Offered $100 USD - After sales service / troubleshooting for 1 month
$200 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I am a college student in Sri Lanka studying business management currently work to find some money for my education. So im looking for a part time job and i'm having fluent skills all ict related work
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Duster hi there, i can help you with this macro. i have experience in working with various Excel tools and application and i can complete the task in one day. looking forward to hearing from you soon.
$111 USD in 1 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED KINGDOM
Braintree, United Kingdom
5,0
322
Metodo di pagamento verificato
Membro dal ago 4, 2006

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.