Devam Ediyor

I need an excel/sheets expert, VBA macros etc

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.

Beceriler: Excel, Visual Basic, Veri Girişi, Veri İşleme, Uygulamalar için Visual Basic

Daha fazlasını gör: display data values excel chart using vba macros, i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need a facebook expert uk, i need a lightroom expert in the uk, i need a numbers expert, i need a photoshop expert, i need a wamp expert, i need a wordpress expert, I need an SEO expert, i need a facebook expert, i need a facebook expert to help, i need a marketing expert, i need a marketing expert to promote my product, i need an analytics expert, i need a pdf expert, i need a photoshop expert in or near santa monica, i need a photosjop expert, i need a php expert's help, i need a twitter expert

İşveren Hakkında:
( 0 değerlendirme ) Prague, Czech Republic

Proje NO: #29960249

Seçilen:

MonisZafar

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(24 Değerlendirme)
4.9

Bu iş için 15 freelancer ortalamada €115 teklif veriyor

(276 Değerlendirme)
6.4
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within some hours

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(119 Değerlendirme)
6.0
borispetrovfrl

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

€90 EUR in 3 gün içinde
(16 Değerlendirme)
3.9
awaishassanw3

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

€140 EUR in 7 gün içinde
(3 Değerlendirme)
1.5
TaranenkoKirill

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

€100 EUR in 2 gün içinde
(0 Değerlendirme)
0.0
jcadaext

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 in 7 gün içinde
(0 Değerlendirme)
0.0
heming912

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 in 3 gün içinde
(0 Değerlendirme)
0.0
ashrafulhaque5ja

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

€140 EUR in 7 gün içinde
(0 Değerlendirme)
0.0
mukesharmy

I am do work this project with my happy. so, I want to do work online mode with my full dedication.

€140 EUR in 7 gün içinde
(0 Değerlendirme)
0.0
SAM3582

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 in 7 gün içinde
(0 Değerlendirme)
0.0
umeshch88

Iam an excel expert hopefully can help you here . please do connect and get this thing resolved .

€140 EUR in 7 gün içinde
(0 Değerlendirme)
0.0
amauricios

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 in 3 gün içinde
(1 Yorum)
0.0
robertocapra

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

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

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

€175 EUR in 7 gün içinde
(0 Değerlendirme)
0.0