I would like to hire an Excel Expert

I need a macro to loop through order template, extract each order and create one flat excel file

with one row for each order.

So it should do:

-prompt for a directory location x

- for each file in directory, x:

a. open the file and look for a tab "order"

b. copy specific header fields from the order like customer name etc

c. copy each row of detail such as sku and order qty (there will be one row per sku)

d. write the above (one row of output per material will be written, with headers repeated

for each row)

The result will be one large file per directory

Skills: Excel, Software Development, Visual Basic

See more: need excel expert on hire, ms excel expert for hire, microsoft excel expert for hire in atlanta ga, excel expert for hire sheffield, excel expert for hire melbourne, excel expert for hire las vegas, excel expert for hire in delhi, excel expert for hire, i have 1 question for a amazon expert for hire, excel expert sg hire, excel expert on hire, excel hire equipment software, professional ezine expert writer hire, excel hire, expert excel vba, data analysis excel hire, expert excel macro, become expert excel modeler

About the Employer:
( 0 reviews ) Mexico

Project ID: #14410540

41 freelancers are bidding on average $104 for this job


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$100 USD in 1 day
(207 Reviews)

Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.

$100 USD in 3 days
(208 Reviews)

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. Relevant Skills and Experienc More

$147 USD in 3 days
(21 Reviews)

Hello, i am ready to start the project. I am very much interested in this task. Relevant Skills and Experience Data Entry Proposed Milestones $55 USD - Default

$55 USD in 3 days
(110 Reviews)

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. More

$75 USD in 3 days
(124 Reviews)

Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/script More

$112 USD in 3 days
(103 Reviews)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex More

$66 USD in 1 day
(147 Reviews)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other Relevant Skills and Experience Excel Proposed Milestones $222 USD - More

$222 USD in 1 day
(62 Reviews)
$200 USD in 2 days
(30 Reviews)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$100 USD in 3 days
(45 Reviews)

Hi I hope all's well with you. I see you'r looking for a developer proficient in Excel/VB. Really all my projects here I've developed for Ms Access/Ms Excel/VB projects. I'll do your current Ms Excel/VB projec More

$155 USD in 3 days
(27 Reviews)

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. thank you so much. Relevant Skills and Experience Excel and Accounting. Proposed Milestone More

$120 USD in 1 day
(61 Reviews)
$222 USD in 3 days
(3 Reviews)
$55 USD in 1 day
(26 Reviews)
$105 USD in 3 days
(12 Reviews)

I’ve 5 years of experience of MS Excel especially with pivot tables, charts, advance formulas and VBA codes Relevant Skills and Experience MS Excel, Visual Basic Proposed Milestones $80 USD - Upon Completion Do let More

$80 USD in 1 day
(19 Reviews)
$155 USD in 3 days
(16 Reviews)
$60 USD in 2 days
(9 Reviews)

Give me more details about

$70 USD in 5 days
(8 Reviews)
$155 USD in 3 days
(4 Reviews)