Find Jobs
Hire Freelancers

Data processing using Excel Macro/Excel VBA

$30-250 USD

I përfunduar
Postuar over 5 years ago

$30-250 USD

Paguhet në dorëzim
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.
ID e Projektit: 17830091

Rreth projektit

24 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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 forward to chat further and work on your project
$100 USD në 3 ditë
5,0 (46 përshtypje)
4,9
4,9
24 freelancers are bidding on average $144 USD for this job
Avatari i Përdoruesit
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 në 5 ditë
4,9 (281 përshtypje)
7,2
7,2
Avatari i Përdoruesit
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 regularly and know exactly how to handle them. You mention that you need somebody to develop the required code for you. I'm going to spend less than 2-3 days to complete your project including required revisions for a total payment of $180. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
$180 USD në 3 ditë
4,9 (161 përshtypje)
6,8
6,8
Avatari i Përdoruesit
Hello, can do this project. will do it with 100% accuracy. hope to hear from u. will deliver on time Thanks Nidhi
$250 USD në 3 ditë
4,8 (93 përshtypje)
6,0
6,0
Avatari i Përdoruesit
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 accessories in the BOM list along with all sorted main items. I will build this VBA macro for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
$155 USD në 5 ditë
5,0 (47 përshtypje)
5,2
5,2
Avatari i Përdoruesit
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 në 3 ditë
4,8 (34 përshtypje)
5,0
5,0
Avatari i Përdoruesit
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, data automation, financial modeling and various other computations, analysis and automation. I will be happy to discuss in detail regarding my qualification, experience and how I am highly suitable for this project.
$60 USD në 1 ditë
4,7 (39 përshtypje)
5,1
5,1
Avatari i Përdoruesit
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 projects in my work history area. I am waiting to be hired in this project to show my skills. Regards
$111 USD në 3 ditë
4,9 (10 përshtypje)
4,1
4,1
Avatari i Përdoruesit
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 and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$200 USD në 3 ditë
5,0 (7 përshtypje)
2,8
2,8
Avatari i Përdoruesit
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 në 2 ditë
5,0 (4 përshtypje)
2,5
2,5
Avatari i Përdoruesit
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 a fair rate that is perfectly adjusted to your budget. Please contact me to get more information regarding this project, I'm interested and have time to dedicate. Regards.
$150 USD në 4 ditë
4,7 (12 përshtypje)
2,8
2,8
Avatari i Përdoruesit
being an engineer i believe i can do the job in better way. i have also worked on Oracle to generate BoM.
$100 USD në 3 ditë
5,0 (2 përshtypje)
2,2
2,2
Avatari i Përdoruesit
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 në 5 ditë
5,0 (1 review)
2,0
2,0
Avatari i Përdoruesit
Hi. My name is Pinki Verma. I am a new freelancer but I am not new to this work I m doing this work almost for a year now. I am really good at typing, excel work etc. I supply your work with 100% accuracy and in time. Because I am new at freelance I also provide you a discount. so please give me a chance psoni1368///pankajvverma6///gmail
$88 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I am a statistics students and knows how to conduct SPSS,R,STATA and expert in data entry, typing
$111 USD në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi dear. I had a through look for your attachment and feel confident. If you hire me, I will deliver you perfect result as soon as possible(2 days). I am open to your suggestion for budget. Regards
$250 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I offer my experience of 20 years working daily with Excel, developing office applications (word, Excel, PowerPoint, etc.)
$177 USD në 10 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 changes till you are satisfied. Hope you consider my bid. Regards Harman
$222 USD në 10 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
excel expert
$155 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 worked with BoMs for many years and would be happy to assist you in delivering a fully functioning and automated spreadsheet that meets your requirements. Thanks in advance for your consideration. Kind regards, Graham
$133 USD në 7 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i UNITED STATES
Miramar, United States
5,0
1
Mënyra e pagesës u verifikua
Anëtar që nga sht 21, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.