Excel formulas and macro

Job Description:

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.

Habilidades: Excel, Visual Basic, Processamento de dados, Visual Basic para Apps, Excel Macros

Sobre o Cliente:
( 1 comentário ) Fort Myers, United States

ID do Projeto: #36292007

Concedido a:

(1230 Comentários)

66 freelancers estão ofertando em média $253 nesse trabalho


Top 1% in 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 Mais

$300 USD in 7 dias
(575 Comentários)

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 Mais

$50 USD em 1 dia
(216 Comentários)

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

$99 USD em 1 dia
(243 Comentários)

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 Mais

$10 USD em 1 dia
(52 Comentários)

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

$10 USD em 1 dia
(122 Comentários)

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 Mais

$450 USD in 7 dias
(21 Comentários)

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 Mais

$335 USD in 4 dias
(152 Comentários)

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 Mais

$500 USD in 2 dias
(7 Comentários)

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, Mais

$70 USD em 1 dia
(63 Comentários)

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 Mais

$500 USD in 7 dias
(23 Comentários)

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 Mais

$500 USD in 7 dias
(20 Comentários)

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 Mais

$100 USD in 2 dias
(10 Comentários)

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 in 14 dias
(14 Comentários)

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 Mais

$380 USD in 7 dias
(13 Comentários)

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 Mais

$255 USD in 2 dias
(7 Comentários)

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 Mais

$255 USD in 6 dias
(4 Comentários)

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 em 1 dia
(4 Comentários)

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 Mais

$200 USD in 2 dias
(2 Comentários)

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 Mais

$500 USD in 2 dias
(0 Comentários)

Hi there, How r u? I bid as i believe that I can help you with this project as i have the experience with Excel Macros, Visual Basic, Data Processing, Excel and Visual Basic for Apps. here is my portfolio: https://www. Mais

$500 USD in 8 dias
(0 Comentários)