Find Jobs
Hire Freelancers

Create a Macro for an Indented Bill of Materials

$30-250 USD

Închis
Data postării: circa 4 ani în urmă

$30-250 USD

Plata la predare
I need to add a column that indicates what is the next level part number on a indented bill of materials. On the example i attached i have an input tab. This is how i receive my data. The export tab is my end goal. The information in column D on the export tab is all based on the bill of material structure in column A in the import tab. The example I uploaded is just a small bill of materials. i need to be able to run this macro for several different bill of materials.
ID-ul proiectului: 24570912

Despre proiect

48 propuneri
Proiect la distanță
Activ: 4 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
48 freelanceri plasează o ofertă medie de $78 USD pentru proiect
Avatarul utilizatorului
HI, I am good at Excel and Vba. I have referred the file containing the input and output formats. It is based on Item No. It is based on the Number at the end of last dot. It picks the previous main category and subcategories. Got it. I would like to discuss and work on the project. -Chandra
$60 USD în 0 zi
5,0 (1262 recenzii)
8,5
8,5
Avatarul utilizatorului
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will populate the table in tab Export after Macro Runs and assigning values in the Next Assembly column. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $80* and can deliver within a day (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 360 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$80 USD în 1 zi
5,0 (682 recenzii)
8,7
8,7
Avatarul utilizatorului
Hello, I can help you with your project - Create a Macro for an Indented Bill of Materials I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD în 4 zile
4,9 (590 recenzii)
8,5
8,5
Avatarul utilizatorului
Hello, I am an Excel/VBA expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.
$50 USD în 1 zi
5,0 (512 recenzii)
8,1
8,1
Avatarul utilizatorului
Hi, I see the logic, and it's a very tricky one. So we have to search the "parent" of the current item based on the hierarchy of the item no. for example for 1.1.2 his parent is the one with item no 1.1 I can code the macro to generate the output tab. I m ready to start. Thanks
$50 USD în 2 zile
4,9 (352 recenzii)
7,9
7,9
Avatarul utilizatorului
Hi, I'm excel vba expert. I've referred the excel attached. The part will refer to the parent path for the next assembly. I've got the process and will get the code done quickly for testing in bigger data. Please chat me for further discussion. Thank you.
$40 USD în 1 zi
5,0 (334 recenzii)
7,9
7,9
Avatarul utilizatorului
Hello Jason, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I can write a macro that takes the Input and generates the Output you want with just the press of a button. The tool will be completely reusable every time. Contact me to discuss the details. Best regards
$50 USD în 1 zi
5,0 (340 recenzii)
7,5
7,5
Avatarul utilizatorului
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 350+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. "
$100 USD în 7 zile
4,9 (281 recenzii)
7,1
7,1
Avatarul utilizatorului
I can do it for you quickly and exactly .Please contact me for saving your time and your moneys .
$100 USD în 1 zi
4,9 (136 recenzii)
7,2
7,2
Avatarul utilizatorului
$39 Only ------- In just 4 Hours ------- I can make a VBA Macro Program for intended bill of materials in export tab by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratting ------ I can start right now, please message me to discuss more. ------- I can send you draft right now.
$39 USD în 1 zi
5,0 (430 recenzii)
6,9
6,9
Avatarul utilizatorului
Hi, Keen to work on this project. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$30 USD în 2 zile
4,9 (211 recenzii)
6,9
6,9
Avatarul utilizatorului
Hi there, I can definitely help you with that. I am a professional Data Analyst, Data Scientist and Data Visualization expert holding years of experience. in Excel, VBA, SQL, Power BI, Tableau and various other tools to perform automation and develop dynamic and automated tools. I will be happy to discuss in detail how I am highly suitable for this project. Regards, Ravinder
$50 USD în 2 zile
4,9 (166 recenzii)
6,1
6,1
Avatarul utilizatorului
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$90 USD în 3 zile
4,9 (152 recenzii)
6,2
6,2
Avatarul utilizatorului
Hi, it could be done, I can create a button attached to macro that performs all these tasks automatically. I have rich experience in VBA-Macro(Excel, Powerpoint,Access Word, Web scrapping, API, ....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
$50 USD în 1 zi
4,6 (65 recenzii)
6,1
6,1
Avatarul utilizatorului
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$40 USD în 1 zi
4,8 (28 recenzii)
5,1
5,1
Avatarul utilizatorului
Hello, ⭐⭐⭐⭐⭐ i am expert in this kind of jobs samples of my excel VBA jobs ⭐⭐⭐⭐⭐ https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ https://www.freelancer.com/projects/Data-Entry/Capture-data-from-website-website-12641885/ https://www.freelancer.com/projects/php/Write-some-Software-12250366/ ⭐⭐⭐⭐⭐ waiting your answer Regards
$30 USD în 1 zi
4,9 (71 recenzii)
4,8
4,8
Avatarul utilizatorului
HI! I am a entrepenour and Excel/VBA/Macro ans Google Scrpit , Google Sheets expert. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (script). REgards, Juan
$75 USD în 7 zile
5,0 (18 recenzii)
4,6
4,6
Avatarul utilizatorului
Hello, I can help you with the project and create the output table with the "Next Asembly" column. Please send me a message with more details and will start working on it immediately.
$33 USD în 2 zile
5,0 (48 recenzii)
4,6
4,6
Avatarul utilizatorului
Hello. I'm a specialist in Excel and macros programming. I can help you with anything you need to perform.
$30 USD în 2 zile
5,0 (15 recenzii)
3,8
3,8
Avatarul utilizatorului
Hi, I'm a highly skilled Excel VBA professional with 12+ experience in designing reports, reconciliations, ETL (xml, xslt, csv, Excel, EDI, custom format text files), conversions, merges and scalable stand-alone Excel applications. For your solution I can deliver an automated import macro so you won't need to copy/paste your import data. I already have a tree view of your bill of materials so you can visualize your materials (I can send a screenshot on request). Furthermore if you need to export to a file other than an excel sheet I can do it in xml or csv or other custom format of your preference. I'll leave the delivery date as is in case of additional wishes otherwise as is, with tree view, can be delivered immediately. I'm new to this site so sorry for the lack of the history Regards, Ger
$225 USD în 7 zile
4,8 (8 recenzii)
4,1
4,1

Despre client

Steagul UNITED STATES
Catoosa, United States
5,0
1
Metoda de plată a fost confirmată
Membru din mar. 3, 2020

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.