The project is regarding transforming BOM (Bill of Material) data of multiple items in one sheet to separate sheets.
E.g. - A Fan is made from 3 Nos blades, 1 Nos motor and 10 Nos screws. 1 motor in turn is made from 3 m wires and 2 Nos plates. [Nos and m are Unit of measurement - Number and Metre respectively]
So our master excel sheet contains data as -
Fan | .1 | Blades | 3 | Nos
Fan | .1 | Motor | 1 | Nos
Fan | ..2 | Wires | 3 | m
Fan | ..2 | Plates | 2 | Nos
Fan | .1 | Screws | 10 | Nos
Now this sheet needs to be split into 2 sheets -
a. Sheet 1
Fan | 1 | Nos
Blades | 3 | Nos
Motor | 1 | Nos
Screws | 10 | Nos
b. Sheet 2
Motor | 1 | Nos
Wires | 3 | m
Plates | 2 | Nos
Further details given in the attached excel sheet. Since the excel sheet contains more than 100,000 rows, speed of execution of code will be important. If needed the output excel file can be split into files with 100 sheets each. We will need the source code as well.
36 威客就此工作平均出价 ₹6772
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twelve excel vba projects in the past three months. Willing to take up your project. Thank you, Regards.
This needs to be done intelligently with a bingo algorithm seperating the levels of BOM. I have worked in Infosys for 18 years and even hold 2 patents in US. I can give it a shot if project is awarded to me.
Hello, You can check my portfolio here on freelancer to see some of my previous work using Excel macros. My bid contains the final price and time I need to deliver this. Best regards, Madalina