Færdiggjort

Data processing using Excel Macro/Excel VBA

I have to sort Bill of Material data that I am getting from Inventor and than associate additional material to that data and arrange it in a pre-defined format.

Images attached are explained below.

1. BOM (Bill of material) exported from Inventor.(saved as "name of [login to view URL]")

2. Workbook 2 (can be called as Association), In this workbook, sheet 2 should have the macro that processes the data and give the output on sheet 1 and than saves it as the same name but can be with .xlsx to have the excel file in same folder. (This is open for discussion,to find out the best way to do this).

3. For association part I have one database excel sheet that I have attached. It has info about the top level parts and what accessories goes with those parts. for example. the first tab on this sheet (8030-001) and it defines that what association always goes with it. like gasket G01, qty2 always should be added when it sees this profile in BOM.

4. It should check the parts in the BOM and associate the accessories and put it under the BOM list. see image attached.

We can discuss in detail after the start of project.

Evner: Databehandling, Excel, Excel Macros, Visual Basic, Visual Basic for Apps

Se mere: macro importing excel project, vba excel project beginning, projects data processing using visual basic, click button using macro vba internet, download file using ftp vba excel, macro paste excel project, macro vba excel example, vba excel project stand alone, excel data entry using macro, find text powerpoint using macro vba, market research data processing using quantum, convert vba excel project vb project, macro vba excel saves stats file, small vba excel project, macro vba excel create invoice word document, separate data ultraedit using macro, using macro export excel data, data processing using excel pdf

Om arbejdsgiveren:
( 1 bedømmelse ) Miramar, United States

Projekt ID: #17830091

Tildelt til:

sloker18

I am proficient with excel macro/VBA development, I can write the macro to reorganize the data as specified, if you are interested feel free to message me, I am available to start your project immediately, looking forw Flere

$100 USD in 3 dage
(46 bedømmelser)
4.9

24 freelancere byder i gennemsnit $144 på dette job

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.

$200 USD in 5 dage
(281 bedømmelser)
7.2
paris2785

Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with Flere

$180 USD in 3 dage
(161 bedømmelser)
6.8
Nidhijain123

Hello, can do this project. will do it with 100% accuracy. hope to hear from u. will deliver on time Thanks Nidhi

$250 USD in 3 dage
(93 bedømmelser)
6.0
TechnoGuruu

Hi, I have checked your project description and attached files in details. So, in this project first thing we have to do sorting as per position in the given format and after that we have to add the associated acces Flere

$155 USD in 5 dage
(47 bedømmelser)
5.2
c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.

$100 USD in 3 dage
(34 bedømmelser)
5.0
daniyal3214

I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to develop highly dynamic and automated dashboards and templates for data analysis, Flere

$60 USD på 1 dag
(39 bedømmelser)
5.1
akritisood94

I can assure you that I will be able to assist you in your task in time with quality work. I have already completed so many projects. Please have a look on my portfolio and profile. I have listed many successful projec Flere

$111 USD in 3 dage
(10 bedømmelser)
4.1
paulodayto08

Hi Good Day! I can help you to complete your Excel works in 2-3 days. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template a Flere

$200 USD in 3 dage
(7 bedømmelser)
2.8
dalsaniyasonu123

Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.

$166 USD in 2 dage
(4 bedømmelser)
2.5
ReneRondon

Hello. I bid for this project because I'm a professional with a lot of experience in MS Excel and VBA programming (macros). I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of Flere

$150 USD in 4 dage
(12 bedømmelser)
2.8
jalileng

being an engineer i believe i can do the job in better way. i have also worked on Oracle to generate BoM.

$100 USD in 3 dage
(2 bedømmelser)
2.2
themuntaha

Hi, I have expertise in Excel (Advance, Functions & VBA). I can do whatever you need through excel if all needed information is provided. Please check my profile for your reference. Regards

$150 USD in 5 dage
(1 bedømmelse)
2.0
gowen55

Hello. I currently work for a manufacturing company and I am a Senior BI Developer in Manufacturing and Supply Chain. I am an Excel expert and I have good knowledge of supply chain and manufacturing processes. I have Flere

$133 USD in 7 dage
(0 bedømmelser)
0.0
ahzamshadab

excel expert

$155 USD in 3 dage
(0 bedømmelser)
0.0
dependabledev1

Hey there, I am interested in your project and believe can complete it satisfactorily. A little about myself: I am a programmer with 8 years of corporate experience and dabbing my hands into freelancing. I can make ch Flere

$222 USD in 10 dage
(0 bedømmelser)
0.0
Bigpetroman

I offer my experience of 20 years working daily with Excel, developing office applications (word, Excel, PowerPoint, etc.)

$177 USD in 10 dage
(0 bedømmelser)
0.0
afrindu

I am a statistics students and knows how to conduct SPSS,R,STATA and expert in data entry, typing

$111 USD in 5 dage
(0 bedømmelser)
0.0
$111 USD in 5 dage
(0 bedømmelser)
0.0
$111 USD in 5 dage
(0 bedømmelser)
0.0
azminnaharnipa66

7. HI, MYSELF AZMIN NAHAR .I AM AN EXCEL EXPERT. I AM EFFICIENT IN MICROSOFT OFFICE TOOLS AND ALSO ITEMS, PROOFREADING ETC. I CAN WORK ON ANY KIND OF EXCEL WORK. EXPERIENCE IN RESEARCH, CATEGORIZING

$155 USD in 3 dage
(0 bedømmelser)
0.0