In Progress

Need a complex set of Excel functions and macros created to process a list of customer orders

Hello,

I am in need of a large multi-step Excel macro that is able to process a text file list of customer orders, and retrieve and transcribe information from within other spreadsheets. Here is the overall outline of what is needed:

1) An excel action will import a list of customer orders from a text file into an excel spreadsheet (*.xls/.xlsx/xlsm), creating new rows in a data table for each order

2) The data table will reference other spreadsheets to interact with and retrieve more information, and fill in blank cells with this information

3) The data table is transcribed into a new spreadsheet file. This data transferred will be customer order information, such as address, package weight, etc. (I will then be using this new spreadsheet to upload directly into [url removed, login to view] shipping software after each running of the script)

This set of Excel actions will contain many small, specific steps that are all already designed to perfectly and efficiently retrieve and gather information from within the different spreadsheets. I have worked out all the steps; I just need someone who knows the syntax to go in and set up all the structures so that it can all be conveniently executed. There are three distinct phases to the project as outlined above; each phase contains about 20 variables that will need to be retrieved/transcribed.

** You should be well-versed with Excel functions and be able to combine/reference information across numerous spreadsheets

** This script should be able to be easily repeated again and again for any set of customer orders, not just for one set list of customer orders.

** In the future, I will be paying for programmers to create additional scripts as modules for this process. So, the actions should not be "closed off" in any way from further insertion of code.

** I will give higher preference to an American who speaks English for this project. This is simply for the easier communication.

Skills: Data Processing, Excel, Logistics & Shipping, Transcription

See more: what is data structures in c, what is data structures, what is a data structures, what are data structures in c, what are data structures, table customer, set data structures, programmers excel, one off programmers, new data structures, need for programmers, list of programmers, list of data structures, list in data structures, list data structures, i need a c++ programmers, different data structures, data structures set, data structures reference, data structures list, customer table, action script list, about data structures in c, about data structures, creating complex functions excel

About the Employer:
( 5 reviews ) Madison, United States

Project ID: #4125065

Awarded to:

FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$120 USD in 3 days
(38 Reviews)
5.1

11 freelancers are bidding on average $153 for this job

simplicityq88

Hello Scott, as a well-educated computer engineer I would love to offer you my services. Please refer to your PM for more details.

$200 USD in 7 days
(143 Reviews)
6.3
nagybatonyi

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of b More

$150 USD in 4 days
(40 Reviews)
5.6
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$185 USD in 7 days
(21 Reviews)
5.2
pkcyber

See your PMB

$150 USD in 2 days
(18 Reviews)
5.1
adim

Top 1% in VBA on Freelancer and lot of experience in this field, please check PM.

$160 USD in 3 days
(5 Reviews)
3.3
TopCSharp

Hi, I am ready to work with your project with full experience and skill.

$150 USD in 7 days
(3 Reviews)
3.1
JScottArnold

Evening- I am a master of Excel macros and can write you what you need. I have attached a file that does some workbook manipulation that shows some of the things I can do. I look forward to working with you!

$125 USD in 5 days
(1 Review)
2.8
bharat1010

Expert in excel/macros. Please check PM.'

$150 USD in 5 days
(2 Reviews)
2.2
minhchauprp

Dear Scott!, i have many experience in working with Excel and Vba. I think i can do this job in good way. Send me all your sample data such as text of customer, other spreadsheets need to refer, i will make the first c More

$150 USD in 2 days
(1 Review)
2.1
Excelomatic

Hi. I'm a planning and control manager for global industrial company. I work daily with excel formulas some of which incorporated into macros. VBA programming is part of my weekly work, integrating between several sp More

$140 USD in 2 days
(0 Reviews)
0.0