Create Excel Makro or Formula for Content Editting

Completed Posted Dec 27, 2014 Paid on delivery
Completed Paid on delivery

I need an excel macro or formula to edit a content of my file.

Check attached excel sheet. Yellow lines are main products, blue lines includes colour and size information of main product. I need to compile these colour and size data in following format:

Colour1:TotalStockAmount1|Colour2:TotalStockAmount2

Size1:StockAmount1|Size2:StockAmount2

Check green line to see result.

Every colour and size row includes code of root product so you can easily assign it to root product.

Contact me if you have any question.

Thanks.

Excel

Project ID: #6910069

About the project

3 proposals Remote project Active Dec 27, 2014

Awarded to:

gokulanand

As discussed, I will get this task done in the next 2 to 3 hours. Thanks

$25 USD in 0 days
(19 Reviews)
4.3

3 freelancers are bidding on average $28 for this job

Teloquence

Hello sir, I am PREFERRED freelancer in excel and related skills on this forum with 200+ five star reviews. I have understood your requirement and I am ready to start the implementation immediately. Looking forward to More

$30 USD in 0 days
(244 Reviews)
7.1
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$29 USD in 0 days
(82 Reviews)
5.9