In Progress

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

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.

Skills: Excel, Microsoft Office

See more: custom excel invoice template, excel invoice template with automatic invoice numbering, excel invoice template , excel invoice template pos, pdf excel invoice template, can quickbooks import excel invoice template, macro excel download url password protected, excel invoice template import quickbooks, import excel invoice template quickbooks, quickbook import invoice template excel, quickbooks pro 2009 can export invoice template excel, excel invoice number macro, quickbooks excel invoice template, design invoice template excel, unlock excel password protected cut paste vba

About the Employer:
( 259 reviews ) Braintree, United Kingdom

Project ID: #15441689

Awarded to:

dayakmlt

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 More

$80 USD in 3 days
(14 Reviews)
3.3

29 freelancers are bidding on average $134 for this job

someka

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 a More

$315 USD in 7 days
(138 Reviews)
7.0
bouslimi1979

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 More

$100 USD in 2 days
(165 Reviews)
7.1
HardWorker1989

"DUSTER" Hi there. I have just the right kind of solution that you need. Have a look at the sample: [url removed, login to view] Relevant Skills and More

$100 USD in 2 days
(71 Reviews)
6.7
avinav606lx

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 Than More

$244 USD in 3 days
(128 Reviews)
6.3
paris2785

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 Exp More

$95 USD in 1 day
(115 Reviews)
6.4
$250 USD in 5 days
(117 Reviews)
6.2
ksriniravi

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 More

$60 USD in 1 day
(112 Reviews)
6.2
tasleem83

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 w More

$250 USD in 3 days
(80 Reviews)
5.2
narsim3128

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 days
(31 Reviews)
4.8
standarditech

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 More

$30 USD in 1 day
(66 Reviews)
4.8
surangs

Hi, I can do this project accurately and deliver in few hours...

$30 USD in 3 days
(9 Reviews)
3.0
insidenetsoft

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 t More

$90 USD in 2 days
(12 Reviews)
2.7
TheReaperCooL

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 Experie More

$111 USD in 3 days
(2 Reviews)
2.8
jamestavs

DUSTER. Hi, I can only download one Excel but having checked it and reading your description I'm quite positive it can be done easily. I will commit to 100% satisfaction with the Excel I produce. Relevant Skills and E More

$200 USD in 5 days
(2 Reviews)
1.2
MizanurWorker

[url removed, login to view] Dear Sir, I read your project and I understand that what type of rearmament do you need to complete this project .After the test if think I'm good fit for your project Then please hire me Relevant Skills More

$55 USD in 3 days
(2 Reviews)
0.8
sanjibpaul91

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 day
(0 Reviews)
0.0
ghamadi87

DUSTER The Invoice Number will be generated using Excel functions (it depends on the value in Contractor Initials & date entered), the rate and contractor info + bank details will be changed via VBA. Relevant Skills More

$80 USD in 3 days
(0 Reviews)
0.0
israthrimi

Hi, I am interested to your job. Relevant Skills and Experience Excel, Microsoft Office Proposed Milestones $155 USD - Project milestones

$155 USD in 3 days
(0 Reviews)
0.0
dinushika777

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 days
(0 Reviews)
0.0
tr65187

DUSTER, I am interested in the job after going through the Samples you sent in excel. I am very experience in it and i wish you work with you. Relevant Skills and Experience Am a microsoft Office Expert and can also More

$155 USD in 3 days
(0 Reviews)
0.0