Find Jobs
Hire Freelancers

I need an excel/sheets expert, VBA macros etc

€30-250 EUR

Dalam Kemajuan
Disiarkan hampir 3 tahun yang lalu

€30-250 EUR

Dibayar semasa penghantaran
Hello, I need help with a sheet I am creating, it is in Zoho, but it seems to be almost identical to Excel and Google sheets. Basically I am creating a template to be used for a PEO type company. We hire employees on behalf of our end clients in Countries they do not have a presence in. This means we have, many clients, with differing Countries, currencies, products, and employees. Our "products" are therefore fees rather than specific goods. I would like a template to be created (or the existing one adjusted) which functions all the time, whether I add an employee, country, product, or if I adjust or remove any of the above. I have made one such spreadsheet (one sheet per client), but the moment I change anything it will cease to be useful. So I would like help with this. Currently I simply use the = this cell function. Which as you can imagine is open for lots of error if something is changed. Important factors, are to have a live status report as seen in the employees tab. Country sheets (e.g. PLN) are shared via IMPORTRANGE with our local payroll teams who calculate the monthly employer contributions etc. their response is recorded also via IMPORTRANGE back into the Country sheet directly. and then all of this feeds back into the source sheet. Invoice sheets (e.g. PLN INV) are used to compile all the information for bulk upload to our accounting software to produce an invoice. Lines with a zero amount should not appear as the bulk upload will not work if the item price (column u) is 0. Ideally, currencies will update daily according to the source website listed in column D of the currencies sheet. Since there are so many products and fees, I have compiled space for the 7 most used ones and all the rest will be added as Other fees in one line. However, if the notes section of the INV sheet can include the fee name and the amounts. i.e. if row 13 is not empty add Row 4 of the same column into the notes. Additionally, these 7 most used fees/products are different for each client. they can even be different for a Country within one sheet. Payroll teams have their own sheets, because we need to anonymise the data, i.e. the German team cannot see the information of the Bulgarian team and vice versa. Hence the IMPORTRANGE formulas. Unfortunately this means that since we use the same sheets each month we need to wipe the data at some point. I know how to write a macro to do this but I dont want to log in to every single Payroll team sheet and wipe all of them individually. Is there a way I can click once and it will clear the contents of multiple worksheets simultaneously? Or perhaps have one macro for each sheet and then a master macro to trigger them all? The inputs sheet is where we obtain the data from the clients with monthly salary variables added, this should automatically fill in the source sheet according to the name of the employee and the type of variable. The source sheet has multiple lines because when we upload an invoice it must be one item per line. But this is not technically necessary for the Please take a look at the sheet here. [login to view URL] I have added a video to the files tab. Happy to have a call to discuss further if you have any questions. Many thanks, Brook.
ID Projek: 29960249

Tentang projek

15 cadangan
Projek jarak jauh
Aktif 3 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. If interested, we can discuss this further on chat.
€80 EUR dalam 1 hari
4.5 (24 ulasan)
4.9
4.9
15 pekerja bebas membida secara purata €115 EUR untuk pekerjaan ini
Avatar Pengguna
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
€120 EUR dalam 1 hari
4.9 (119 ulasan)
6.0
6.0
Avatar Pengguna
Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Processing. I am the best suitable candidate to serve you. If you hire me, I will provide you good result. Let's discuss details about your job in chat. Thanks, Good luck.
€90 EUR dalam 3 hari
4.5 (16 ulasan)
3.9
3.9
Avatar Pengguna
Hello, I'll be happy to assist you in regards EXCEL i can help with task in minimal package & minimum time with 100 % accuracy i will keep you posting about recent update i will be Taking Photo Screenshots & Uploading to Dropbox project. I can work with you during the next hours to have this done. Please contact me to discuss further details! 10% discount HACAN
€140 EUR dalam 7 hari
5.0 (3 ulasan)
1.5
1.5
Avatar Pengguna
⭐⭐⭐⭐⭐ Dear Client. The best quality and the fastest delivery speed are promised ⭐⭐⭐⭐⭐ I have checked your details carefully and confident I can finish this project perfectly. I have rich experiences about Excel VBA over 5 years of hard working. If you give me a chance, you will get the greatest satisfy. Please ping me via chat. Best regards. Kirill.
€100 EUR dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
i have experience of proven data entry work, MS office, I am acquainted with administrative duties. Also, I have a high school diploma and certificate of computer training course-work.
€140 EUR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
give your project and get good results on time for future projects trust me I, honesty I am fresher for your projects but I give my best efforts to complete your project without error.
€72 EUR dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am professional transcriptionist and translator and also expert in Date Entry, fillable PDF FORM, Typing PDF CONVERSION. you will receive your material quickly and accurately. I am here to provide quality to satisfy the need of clients and have ability to show my skill on time at low cost. Looking for long term business relationship.  Flexible typing  Reasonable cost  Highly quality output  Unlimited revision  24x7 Available
€140 EUR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am do work this project with my happy. so, I want to do work online mode with my full dedication.
€140 EUR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am very interested this project and my profession is a data entry and Excel etc. Your project per time complete and as sson as possible
€130 EUR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Iam an excel expert hopefully can help you here . please do connect and get this thing resolved .
€140 EUR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I have so much experience on Excel/Macros/VBA for more than 11 years. I am pretty sure I can help you to get a great result. We can chat to discuss details and be more assertive in what you want. Thank you!
€40 EUR dalam 3 hari
5.0 (1 ulasan)
0.0
0.0
Avatar Pengguna
I have +20 years of experience in Excel Spreadsheets using VBA for automation. I have similar projects and I can make it quick and 100% bug free. My projects are clean, 100% code understandable and you have my support after conclusion.
€100 EUR dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Dear Sir...../ Dear Mam..... Good Evening..... With My Well Experience..... Expert Here.... In UAE: Abu Dhabi / Dubai..... We Can Handle.....This your project for you if given the opportunity..... We Are More Serious..... To Deliver This Project..... As Requested..... Thanks & Best Regards.....
€175 EUR dalam 7 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera CZECH REPUBLIC
Prague, Czech Republic
0.0
0
Ahli sejak Apr 22, 2021

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.