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.
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
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
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
"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
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
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
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
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
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
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
Hi, I can do this project accurately and deliver in few hours...
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
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
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
[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
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.
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
Hi, I am interested to your job. Relevant Skills and Experience Excel, Microsoft Office Proposed Milestones $155 USD - Project milestones
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
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