I need a excel expert
- or -
Post a project like this2393
£60(approx. $75)
- Posted:
- Proposals: 6
- Remote
- #1695650
- Awarded
TOP CERT Virtual Assistant, Data Analyst, Proofreader, Excel, Word and PowerPoint Trainer
Swindon
Virtual Assistant, Admin support, Zendesk Support,Data entry, Website Administrator, Business Support, HubSpot , CRM
Royston
1267140752649811286114137216753721815975
Description
Experience Level: Expert
Estimated project duration: 1 day or less
I have 16 excel spreadsheets of client data and I need them all merged into one master excel sheet. I want the executives rearranged by order of company name in an alphabetical order so that the final sheet has the data formatted in this order:
Company name Executive name Executive Job Title Executive Business Email Address Executive Direct Email Address Executive Mobile Phone Number Executive Work Phone number PA name PA mobile PA work phone number company address company phone number executive location What level of authority do you hold? What is your personal budget? What is your department budget? What ERP solution do you have in place? Do you use SAP?
Some of the sheets have multiple tabs, and there is likely to be some of the same executives appearing across the different 16 sheets. I dont mind there being duplicate representatives e.g joe.bloggs@unilever.com appearing a few times on the master spreadsheet but what is important is one master spreadsheet with every single contact from the 16 spreadsheets appearing on it in the order in which I want them to appear. Not all of the data will be there to populate all of the fields outlined above for each executive but there will be plenty of date for every executive to complete the majority of the cells i.e
Company name Executive name Executive Job Title Executive Business Email Address Executive Direct Email Address Executive Mobile Phone Number Executive Work Phone number PA name PA mobile PA work phone number company address company phone number executive location What level of authority do you hold? What is your personal budget? What is your department budget? What ERP solution do you have in place? Do you use SAP?
Company name Executive name Executive Job Title Executive Business Email Address Executive Direct Email Address Executive Mobile Phone Number Executive Work Phone number PA name PA mobile PA work phone number company address company phone number executive location What level of authority do you hold? What is your personal budget? What is your department budget? What ERP solution do you have in place? Do you use SAP?
Some of the sheets have multiple tabs, and there is likely to be some of the same executives appearing across the different 16 sheets. I dont mind there being duplicate representatives e.g joe.bloggs@unilever.com appearing a few times on the master spreadsheet but what is important is one master spreadsheet with every single contact from the 16 spreadsheets appearing on it in the order in which I want them to appear. Not all of the data will be there to populate all of the fields outlined above for each executive but there will be plenty of date for every executive to complete the majority of the cells i.e
Company name Executive name Executive Job Title Executive Business Email Address Executive Direct Email Address Executive Mobile Phone Number Executive Work Phone number PA name PA mobile PA work phone number company address company phone number executive location What level of authority do you hold? What is your personal budget? What is your department budget? What ERP solution do you have in place? Do you use SAP?
Lenny W.
83% (6)Projects Completed
5
Freelancers worked with
5
Projects awarded
50%
Last project
13 Mar 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies