Closed

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

44 freelancers are bidding on average $107 for this job

esalem

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)
6.8
schoudhary1553

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
(183 Reviews)
6.9
P0L

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
(181 Reviews)
6.7
paris2785

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
(119 Reviews)
6.4
mantislin

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
(89 Reviews)
6.4
avinav606lx

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
(135 Reviews)
6.3
Venkat2011sri

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
(100 Reviews)
6.4
MohsanEijaz

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
(56 Reviews)
5.6
$200 USD in 2 days
(28 Reviews)
5.1
abhinovpankaj

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
(43 Reviews)
5.2
zu02

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
(23 Reviews)
5.5
renesontiongson

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
(45 Reviews)
4.9
$222 USD in 3 days
(3 Reviews)
4.8
$55 USD in 1 day
(21 Reviews)
4.5
$105 USD in 3 days
(12 Reviews)
4.3
orugantn

Hello, I am good with Excel and VBA. I reviewed your requirements to search and import data into a large excel repository. I am interested in the work and expected to complete in 3 days. Please feel free to conta More

$150 USD in 3 days
(19 Reviews)
4.8
$155 USD in 3 days
(16 Reviews)
4.0
awaisjahangir25

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
(12 Reviews)
4.1
$155 USD in 3 days
(4 Reviews)
3.7
conforti

Give me more details about

$70 USD in 5 days
(8 Reviews)
3.6