Excel formulas and macro

Đã hoàn thành Đã đăng vào 6 tháng trước Thanh toán khi bàn giao
Đã hoàn thành 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.

Excel Visual Basic Xử lí dữ liệu Visual Basic cho Ứng dụng Excel Macros

ID dự án: #36292007

Về dự án

65 đề xuất Dự án từ xa 6 tháng trước đang mở

Được trao cho:

(1244 Đánh Giá)

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

$300 USD trong 7 ngày
(588 Nhận xét)

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

$50 USD trong 1 ngày
(225 Nhận xét)

"""""""""""""""""""""""""""""""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

$99 USD trong 1 ngày
(257 Nhận xét)

Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.

$10 USD trong 1 ngày
(127 Nhận xét)

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

$10 USD trong 1 ngày
(59 Nhận xét)

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

$450 USD trong 7 ngày
(22 Nhận xét)

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

$335 USD trong 4 ngày
(154 Nhận xét)

Hi I can help to do this job and can start right now. Need to see source file Regarding my experience you can check my 100% feedback and reviews I have 16+ year experience of Excel, Excel VBA and Have 100% feedback So, Thêm

$70 USD trong 1 ngày
(69 Nhận xét)

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

$500 USD trong 2 ngày
(7 Nhận xét)

I am a Data Scientist. I have 7 years of experience working as a Data Analyst. I can analyze your data in Excel. I can create Custom Scripts/automation in Excel. I can create extensive custom formulas, Dynamic Dashboar Thêm

$500 USD trong 7 ngày
(23 Nhận xét)

I am writing to express my interest in the project to develop formulas and macros to reformat daily data reports from a partner organization for regular data imports into your system. As an expert in data processing, I Thêm

$500 USD trong 7 ngày
(21 Nhận xét)

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

$250 USD trong 14 ngày
(20 Nhận xét)

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

$100 USD trong 2 ngày
(10 Nhận xét)

Hello, I will work on this project until I get good results and complete all the tasks. I am prepared to handle projects requiring Data Processing, Excel skills. Lets connect in chat so that we discuss further. Zie Thêm

$380 USD trong 7 ngày
(13 Nhận xét)

Hi, Dear Employer. I am Al.A. I am a Ph.D. backgrounder and professional Excel and data scraper with over 12+ years of experience. I will provide you high-quality Excel file. I have worked on similar projects of Spre Thêm

$255 USD trong 2 ngày
(8 Nhận xét)

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.

$150 USD trong 1 ngày
(7 Nhận xét)

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

$200 USD trong 7 ngày
(6 Nhận xét)

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

$255 USD trong 6 ngày
(4 Nhận xét)

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

$200 USD trong 2 ngày
(2 Nhận xét)

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

$500 USD trong 2 ngày
(0 Nhận xét)