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.
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. I Plus
15 freelances font une offre moyenne de 115 € pour ce travail
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours
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 Pro Plus
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 & Uploadin Plus
⭐⭐⭐⭐⭐ 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 ove Plus
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.
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.
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 Plus
I am do work this project with my happy. so, I want to do work online mode with my full dedication.
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
Iam an excel expert hopefully can help you here . please do connect and get this thing resolved .
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!
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 Plus
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 Seriou Plus