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.
29 freelancers are bidding on average $134 for this job
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
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.
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