Create Excel Makro or Formula for Content Editting

已完成 已发布的 Dec 27, 2014 货到付款
已完成 货到付款

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

项目ID: #6910069

关于项目

3个方案 远程项目 活跃的Dec 27, 2014

授予:

gokulanand

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

$25 USD 在0天内
(19条评论)
4.3

有3名威客正在参与此工作的竞标,均价$28/小时

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 更多

$30 USD 在0天内
(244条评论)
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 更多

$29 USD 在0天内
(82条评论)
5.9