Excel formulas and macro
$10-500 USD
Thanh toán khi bàn giao
We’re looking develop formulas and a macro to reformat a document for our regular data import process. We receive a report from a partner organization on a daily basis and regularly need to reformat and upload the ticket data into our system. These are the basic requirements to make the sheet ready for our import:
• Partitioning the Name field provided into First, Last, First 2, Last 2 columns
• Partitioning the Csz column into separate city, state and postal code columns
• Removing foreign country zip codes
• Adjusting zip codes that start with 0 (the file does not include the 0 if it’s the leading number)
• Removing extraneous columns
• Removing rows with missing seats/seat locations
• Partitioning the Seat Location column into Section, Row, First Seat, Last Seat columns
• Creating multiple rows in the worksheet if the Seat Location column value represented non-contiguous seats
We have had particular difficulty with the last point, separating non-contiguous seats into separate lines. All the biographical data should be present with above listed formatting, and all data split into multiple lines with the price and total seat count reflecting only the contiguous set of seats from the order.
We receive this file as a .csv and ultimately convert it to tab-delimited text file for import.
I’ve included a document that contains a couple of examples of data as we receive it and reformatted for import, one standard example and one with non-contiguous seats. The first sheet of the document includes the file preparation instructions. More example sheets can be shared in the future.
ID dự án: #36292007
Về dự án
Được trao cho:
65 freelancer chào giá trung bình$256 cho công việc này
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Thêm
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto Thêm
"""""""""""""""""""""""""""""""ADVANCE EXCEL FORMULA'S & MACRO EXPERT"""""""""""""""""""""""""""""""""""""" "Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMAT Thêm
Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project developing formulas and a macro to reformat a document. I'm so responsib Thêm
Hello, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. Considering your requiremets, do you want Thêm
Excel vba expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating Thêm
Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 7+ Years of Experience ★★★ I've read requirements and ready to develop formulas and a macro to reformat a document. I provide complete ranges of solution for Thêm
Hi, I did a little similar project last year, so I know how to do it. I have few years of experience working with Excel VBA Macros. Contact me, please, if you want to get best results. Best regards, Remis
Hi I have read your description carefully. I have rich experiences in ⭐ Excel, Web Scraping, formula, vba, macro, data entry. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly m Thêm
Hi, Exel Expert Here, I can develop formulas and a macro to reformat a document for your regular data import process. I can easily do this job with all given instructions. Thanks.
Hello, I am a new freelancer. I have professional experience of more than 10 years in Excel VBA. I am working in a reputed MNC and have worked and delivered multiple projects/dashboards in Excel VBA. I can help you ou Thêm
Greetings, I have more than 10 years of experience in professional consultancy regarding Microsoft Excel and Power Bi. I am an expert in formulating scenarios, logic, and criteria outputs based on user requirements. I Thêm
Dear Clients, I have 2 years experience in creating macros and developing formulas in Excel, and I am confident that I can reformat your daily report and prepare it for import. As per your requirements, I will develo Thêm
CERTIFIED ENGINEER, EXPERT IN ENGINEERING&SCIENCE, Dear Client, I have Keenly gone through your project requirements as given in your project description. I gladly inform you that i am in possession of all clearly sta Thêm
