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.

Beceriler: Excel, Microsoft Office

Daha fazlasını gör: 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

İşveren Hakkında:
( 259 değerlendirme ) Braintree, United Kingdom

Proje NO: #15441689



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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 80%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(14 Değerlendirme)

Bu iş için 29 freelancer ortalamada $134 teklif veriyor


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 Daha Fazla

in %bids___i_period_sub_35% gün içinde315%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(138 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(165 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(71 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde244%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(128 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(115 Değerlendirme)
in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(117 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(112 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(80 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(66 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde90%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

[login to view URL] 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 Daha Fazla

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)