Terminé

Process multiple spreadsheets and create a new one from the data

Our business runs two separate systems, one system is used by engineers to design parts and the other is used by purchasing staff to order components.

Currently the engineers send a spreadsheet to purchasing who have to manually manipulate and enter the date which, wastes a lot of time.

We need a macro/script to be developed that will import two CSV files, analyse the content and compare to a spreadsheet.

If there are new parts on the spreadsheet, it should manipulate the datto create a new sheet that is then used to import into the purchasing system.

The process is explained in the attached PDF and sample files are provided.

The completed Macro / Script must be supplied without password protection so that we may small changes easily in the future.

Compétences : Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps

en voir plus : combine multiple excel sheets into one macro, combine multiple worksheets into one, consolidate data from multiple worksheets in a single worksheet, how to pull data from multiple worksheets in excel, merge multiple excel files into one sheet vba, combine multiple excel sheets into one sheet, copy data from multiple worksheets into one, combine multiple excel files into one workbook separate sheets python, mysql data base pdf, create html data entry, create website data submission, vbnet create access data base, create access data project 2007, create report php using pdf, create web data, excel visual basic grabbing data multiple spreadsheets, flash create multiple choice quiz xml data, create multiple spreadsheets macro, create mysql data report pdf php, php export data print pdf csv

Concernant l'employeur :
( 32 commentaires ) Wangara, Australia

Nº du projet : #18072951

Décerné à:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 4 jours
(647 Commentaires)
8.3

52 freelance font une offre moyenne de $403 pour ce travail

schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Process multiple spreadsheets and create a new one from the data. I can assure you the quality job. I have good experience in Data Processing Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(295 Commentaires)
7.7
seaanddream

Hi, my name is Selim. I read your `Process multiple spreadsheets and create a new one from the data` project descriptions carefully before bidding. I checked the attached templates and instruction as well... I got w Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(276 Commentaires)
7.7
jubair7

Excel pro here to take the project. Experienced FREELANCER HERE to work for your project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(148 Commentaires)
7.3
paris2785

Hello! My name is Paris. According to your brief, you need someone to write a macro that will automate the process you describe in the pdf attachment. I've developed many similar macro-enabled spreadsheets, and I'm Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(172 Commentaires)
6.9
RRajeshR

Hi, I am interested to work on your project. I can implement this in JAVA and provide you the support in case you require. I can assure you the quality and support of the script. Please let me know.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(42 Commentaires)
6.0
customizedata

I have downloaded the "work [login to view URL]" along with csv stuff. 1- Interface to browse "Item" and "Descriptor" csv files along with "[login to view URL]". 2- Macro will read "Painted" or "powder coat" columns 3-if any of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(101 Commentaires)
6.1
SPARKtechBD

I have experience on Visual Basic to build any kind of Windows Application and also VBA to build robust macro to automate Excel sheet. I have read your description and understand your requirements. 15+ years of expe Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(11 Commentaires)
5.6
macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(66 Commentaires)
5.7
rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(55 Commentaires)
5.6
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(62 Commentaires)
5.7
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. Will make multiple sheets into one. Willing to take up your project. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(66 Commentaires)
5.8
Grunty

Hello. I feel I'd do a very good job with your project. Plenty of projects involving Excel with VBA programming in my profile, which you're kindly invited to browse. I'm an MS-Access expert also, still I do apprecia Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(36 Commentaires)
5.5
sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per your requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to hear from Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(54 Commentaires)
5.8
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I saw all attached CSVs and PDF. I understood the Flow Chart and can convert it to VBA macro. I can create a macro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(69 Commentaires)
5.3
sloker18

I am proficient with Microsoft excel and macro/VBA development, I can generate the report dataset as specified, if you are interested feel free to message me, I am available to start your project immediately, looking f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(50 Commentaires)
5.1
citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(58 Commentaires)
5.4
daniyal3214

I am a professional Data Analyst and Excel expert with background in Financial Analysis holding years of experience in utilizing advance level tools and functions of Excel to perform Financial Modeling, Financial Analy Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(43 Commentaires)
5.3
Piao217

Hi I have rich experience in Excel sheet manipulation/building using VBA Macros and Form Fields. If the work is super-complicated, i can even use C#. You can check my profile and past reviews. Let us discuss in mor Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(5 Commentaires)
4.6
expertcoder1vw

Hi, I reviewed your workflow in the PDF, and from the look of it, Excel is not the best solution. What you really need is a separate program developed in Visual Basic that will do this for you. I can develop this Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 10 jours
(16 Commentaires)
4.7
aminw

Hi Phil, I went through your requirement, and this is a classic case of procurement and operations teams being on disparate system. I have faced similar situation on multiple consulting assignment, that I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(6 Commentaires)
4.3