Đã hoàn thành

Linked excel sheets

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic

Xem nhiều hơn: compare excel sheets, posting excel sheets web page, differences excel sheets, how to link sheets in excel 2013, how to link cells in different excel spreadsheets, how to link sheets in excel with a formula, how to link cells in excel same worksheet, how to link data in excel from one sheet to another, how to automatically update one excel worksheet from another sheet, how to link excel sheets to another sheet, automatically update excel spreadsheet from another spreadsheet, customer service excel sheets, combining excel sheets access, company data excel sheets, updating excel sheets manually code visual basic, updating excel sheets manually visual basic, activity log user macros excel sheets, excel sheets uploaded, several excel sheets page, automating emails excel sheets

Về Bên Thuê:
( 0 nhận xét ) United Kingdom

ID dự án: #18168424

Được trao cho:

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 Thêm

£30 GBP trong 3 ngày
(303 Đánh Giá)
7.7

16 freelancer đang chào giá trung bình £147 cho công việc này

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 trong 3 ngày
(281 Nhận xét)
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 Thêm

£222 GBP trong 7 ngày
(108 Nhận xét)
7.0
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 Thêm

£155 GBP trong 3 ngày
(68 Nhận xét)
6.4
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 Thêm

£150 GBP trong 3 ngày
(52 Nhận xét)
5.3
akritisood94

Hi Hope you are doing good. I am an Excel expert .I have a passion to work on macros and [login to view URL] check my reviews once Relevant Skills and Experience Excel macro vab

£150 GBP trong 3 ngày
(21 Nhận xét)
4.8
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 Thêm

£150 GBP trong 3 ngày
(31 Nhận xét)
4.9
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 Thêm

£150 GBP trong 3 ngày
(2 Nhận xét)
0.8
Ezahan

Hire me to this project because I am good at excel

£127 GBP trong 4 ngày
(0 Nhận xét)
0.0
ageorgeionut

Good eavning, I can help you with fixing the issue. I have experience in writing vba code in excel and acces. Best regards,

£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
dashabulyga

I work in the fiels of Logistics and Shipping, big transport company with more than 600 trucks. A signifficant past of my job is concerning support and development relationship with clients and assistance them. I Thêm

£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
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 Thêm

£150 GBP trong 5 ngày
(1 Nhận xét)
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 Thêm

£111 GBP trong 3 ngày
(0 Nhận xét)
0.0
£150 GBP trong 3 ngày
(0 Nhận xét)
0.0
£150 GBP trong 3 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
0.0