Linked excel sheets

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

We add data into the RWN MICS file (employees, sales companies etc) as well as the RWN BDM file (what commission our company, sales companies and our sales consultants receive per project) – this is only done once a new employee starts or new projects get releasedWe input data into the RWN DEAL PROGRESSION – Master file on a daily basis with a row per [login to view URL] data is automatically added to the RWN ACCOUNTS file (the main file! From which all others get their data)In the RWN CLIENT CARE – Master file dates are added to certain columns, which it automatically adds into the ACCOUNTS fileThe RWN ACCOUNTS file automatically adds its data to the RWN SALES CONSULTANT – Master file and RWN SALES COMPANY – Master fileThe RWN SALES CONSULTANT – Master file creates individual files for each employee with their individual deals and payThe RWN SALES COMPANY – Master file creates individual files for each employee with their individual deals and payThe RWN CLIENT CARE – Master file creates individual files for each employee with their individual deals and pay

 

--------------------------------

 

There are a few things currently not working correctly and need fixing (files attached):

 

RWN SALES CONSULTANT – Master file

If data is updated in the RWN ACCOUNTS file in column AG, it is not calculating the correct figure in column U in the RWN SALES CONSULTANT – Master file. See examples highlighted in red in columns AG and U respectively! RWN ACCOUNTS cell AG668 -> RWN SALES CONSULTANT – Master cell U382 (Akhmed Hussain)RWN ACCOUNTS cell AG1207 -> RWN SALES CONSULTANT – Master cell U687 (Deepak Deshpande)RWN ACCOUNTS cell AG1255 -> RWN SALES CONSULTANT – Master cell U714 (Tom Butcher)Seems to work correctly: RWN ACCOUNTS cell AG85 -> RWN SALES CONSULTANT – Master cell U33 (Rishi Kumar Bawa)

 

RWN SALES CONULTANT - User files

In certain RWN SALES CONSULTANT – User files such as Liam file, the hidden cash bonus tab is not updated correctly. I had to create new ones and now they are updating again but still don’t know why some are working and others aren’t Please see newly created correct file and old not working file!If I create a new RWN SALES CONULTANT – User from the RWN SALES CONSULTANT – Master file, everything gets created fine. But if I save and reopen it asks me to enable macro. If I do this all dates show as American!

 

RWN NETWORK CONSULTANT – User file

The RWN NETWORK CONSULTANT – User file such as Sami file, gets created from the RWN SALES COMPANY – Master file. Column N and R need different calculations: column N: Please can you change the calculation is this column as follows: (column J in this file) * (column G * column H in the BDM file on the 'Sales Companies' tab) based on the project in column H in this file and column F in the in the BDM file on the 'Sales Companies' tab. If in the BDM file on the 'Sales Companies' tab, column G * H = 0, please use the amount in column [login to view URL] R: Please can you change the calculation is this column as follows: (column J in this file) * (column I * column J in the BDM file on the 'Sales Companies' tab) based on the project in column H in this file and column F in the in the BDM file on the 'Sales Companies' tab. If in the BDM file on the 'Sales Companies' tab, column I * J = 0, please use the amount in column L.

 

-------------------------------------------

 

Here are the new things we would like to add:

 

RWN SALES CONULTANT - User files

In the RWN SALES CONULTANT – User file such as the Liam file, which gets created from the RWN SALES CONSULTANT – Master file, there is a CASH BONUS tab which is hidden (because it shows the data from all employees from the RWN SALES CONULTANT – Master file). What we would like is that the CASH BONUS tab is not hidden and instead only shows the relevant sales consultants cash bonus entries and no one else’s.

Entrada de datos Procesamiento de datos Excel Visual Basic

Nº del proyecto: #18168424

Sobre el proyecto

14 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Linked excel sheets. I can assure you the quality job. I have good experience in Data Entry, Data Processing, Excel, Visual Basic. We have wo Más

£30 GBP en 3 días
(311 comentarios)
7.8

14 freelancers están ofertando un promedio de £146 por este trabajo

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

£150 GBP en 3 días
(281 comentarios)
7.2
zekovicm

Hi there I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former c Más

£222 GBP en 7 días
(115 comentarios)
7.1
polarjin2017

Hello? How are you? I have good experiences in "Linked excel sheets" as you can see my profile for these (Data Entry, Data Processing, Excel, Visual Basic). I have been working for 7 yrs in this scope. While we con Más

£155 GBP en 3 días
(74 comentarios)
6.5
TechnoGuruu

Hi, I am an Excel expert with multiple years of experience and can write complex macros and formulas. I have expertise in Excel, VBA macros and formulas. I always deliver quality product with high accuracy. I have c Más

£150 GBP en 3 días
(59 comentarios)
5.4
jasalaz100

Hello, I hope you are well. These are my strengths: Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after com Más

£150 GBP en 3 días
(32 comentarios)
4.9
billpinder82

Good day, my name is William. I am an Excel specialist with 10 years of professional experience. I operate an Excel consulting service and I work as a 'Data Administrator' for a local non-profit I have read your proje Más

£150 GBP en 5 días
(2 comentarios)
2.4
mdatikurrahman1

Hello Sir I first of all thank you for posting this job. I am Atik from Bangladeesh. I'm a college students and I'm working here the administrative support category on a part-time basis. I'm a beginner but experince Más

£150 GBP en 3 días
(2 comentarios)
0.8
Ezahan

Hire me to this project because I am good at excel

£127 GBP en 4 días
(0 comentarios)
0.0
Sajee221

DATA ENTRY EXPERT**WEB SEARCHING**EXCEL AUTOMATION**PDF**PROOFING**VA**PHOTOSHOP**TYPING**BOOKS SCANNING I am expert in Data Entry/Data Processing. I am experienced. I have excellent experience of 10 years with such Más

£111 GBP en 3 días
(0 comentarios)
0.0
ExcelSupreme

Hi, I'm an advanced Excel enthusiast, unfortunately new to this site, but I want to freelance to enhance my skills and help people. Describe your issue and let's deal with it. Just that easy!

£200 GBP en 7 días
(0 comentarios)
0.0