I have two Excel tasks that need to be completed today
- or -
Post a project like this1378
£50(approx. $63)
- Posted:
- Proposals: 9
- Remote
- #2900685
- Awarded
Web Researcher, Data Entry , PDF, MS Word and Excel Conversion, VA, Promo videos, Web designer, Wordpress designer, photoshop, Logo design
Coimbatore
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Chartered Accountant , CFA, Microsoft Excel formatting and entry, SOP, Freelancer, Data entry, PDF Conversion , Microsoft Word, Web Research, Transcription
Kolkata
Senior Full Stack Web Developer ✮Blockchain Expert ✮Experienced Graphic Designer ✮WordPress Expert ✮Virtual Assistant ✮ , excel expert ✮ PHP
Islamabad
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
Jhelum
25071369715121406416227163924048952544758278297728402514384478
Description
Experience Level: Entry
TASK NO. 1
I have a Word document which contains 5258 email addresses presented in the following format.
example1@name1.com; example2@name2.com; example3@name3.com etc etc.
This data is to be imported into an excel sheet so we have 5258 rows.
All duplicate email addresses must be removed.
TASK NO. 2
I have two Excel workbooks.
On the ‘Payee Bank Export’ workbook, which contains 2634 records, merge the digits in columns B & C (Sort Code, then Account Number). For example, the digits for row 2 should be: 30159999898
Column B which now contains both sort code and bank account number is to be named ‘Bank Details’.
Now, with the Contact data (Row A) on the Payee Bank Export workbook, we need to find the same Contact (Row A) on the Xero Data workbook (which contains 3779 records). Once located, the data in Column B on the Payee Bank Export workbook for that Contact is to be copied to Column AD on the Xero Data workbook.
Important. On the Xero Data sheet, with the exception of the data to be added to column AD, the remaining data must not be touched i.e Column Headings, Contact Names and everything else must not be changed, removed or added to otherwise the file will not upload to our Xero software.
-----------------------------------------------------------------------------------------------
I am seeking a cost to complete this work today which needs to be done by 22:00 GMT.
I have a Word document which contains 5258 email addresses presented in the following format.
example1@name1.com; example2@name2.com; example3@name3.com etc etc.
This data is to be imported into an excel sheet so we have 5258 rows.
All duplicate email addresses must be removed.
TASK NO. 2
I have two Excel workbooks.
On the ‘Payee Bank Export’ workbook, which contains 2634 records, merge the digits in columns B & C (Sort Code, then Account Number). For example, the digits for row 2 should be: 30159999898
Column B which now contains both sort code and bank account number is to be named ‘Bank Details’.
Now, with the Contact data (Row A) on the Payee Bank Export workbook, we need to find the same Contact (Row A) on the Xero Data workbook (which contains 3779 records). Once located, the data in Column B on the Payee Bank Export workbook for that Contact is to be copied to Column AD on the Xero Data workbook.
Important. On the Xero Data sheet, with the exception of the data to be added to column AD, the remaining data must not be touched i.e Column Headings, Contact Names and everything else must not be changed, removed or added to otherwise the file will not upload to our Xero software.
-----------------------------------------------------------------------------------------------
I am seeking a cost to complete this work today which needs to be done by 22:00 GMT.
Projects Completed
188
Freelancers worked with
141
Projects awarded
51%
Last project
30 Apr 2024
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