Find Jobs
Hire Freelancers

Create Excel Macro or Formula For File Editting

$2-8 USD / hour

クローズ
投稿日: 9年以上前

$2-8 USD / hour

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.
プロジェクト ID: 6909805

プロジェクトについて

21個の提案
リモートプロジェクト
アクティブ 9年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に21人のフリーランサーが、平均$9 USD/時間で入札しています
ユーザーアバター
Hello, I have three years of data administration experience and have done many similar projects before. You can check my profile for positive feedback and reviews. It can be done with the help of formula. Is this the final quantity and product you want to go with ? I assure you of my good quality work. Waiting for your positive reply. Regards, Aisha Ali
$5 USD 20日以内
4.9 (152 レビュー)
7.6
7.6
ユーザーアバター
A proposal has not yet been provided
$22 USD 1日以内
4.9 (251 レビュー)
7.6
7.6
ユーザーアバター
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards.
$16 USD 10日以内
4.9 (224 レビュー)
6.9
6.9
ユーザーアバター
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
$3 USD 1日以内
4.9 (202 レビュー)
6.4
6.4
ユーザーアバター
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 output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$8 USD 3日以内
4.9 (160 レビュー)
6.4
6.4
ユーザーアバター
Hello :) I am not going to quote you 8$/hr and then bid for 2-3 hours. To finish the complete project(no matter how many hours), I bid $33.00 I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not disappointed anyone till date. I have done more than 130 projects. In fact, My reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :) Hope to work with you. Regards Sid
$33 USD 1日以内
4.9 (149 レビュー)
6.5
6.5
ユーザーアバター
Hello, I can get you this task done in the next 1 to 2 hours. Let me know if you are interested. Thanks
$7 USD 2日以内
5.0 (98 レビュー)
6.0
6.0
ユーザーアバター
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$8 USD 1日以内
4.9 (117 レビュー)
6.2
6.2
ユーザーアバター
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$7 USD 3日以内
4.9 (63 レビュー)
5.7
5.7
ユーザーアバター
I will get back to you soon. Thanks.
$3 USD 2日以内
5.0 (122 レビュー)
5.3
5.3
ユーザーアバター
I have over 9 years of experience in Excel, Access and Outlook VBA. I have developed several Tools, Automation, Dashboard, Database CRM and Online Extraction Tools using VBA. I have done a similar kind of project for one of my clients using VBA in outlook.
$6 USD 1日以内
4.9 (12 レビュー)
3.9
3.9
ユーザーアバター
Hello! Thank you for taking your time to read my proposal. I have been in this industry for 6 years and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. I have been read your Project description throughout. I have been made this type of work many times. You can see my PROFILE for more details . See some screenshots of my previous work in my PORTFOLIO. Let's discuss for even more details before you award me the project. Thank you in anticipation. Have a nice day...
$5 USD 10日以内
5.0 (4 レビュー)
3.0
3.0
ユーザーアバター
Hi, I am an expert in Microsoft Excel and I believe this can be done using macro. This is what I am planning to write on my code: Detect if cell color is yellow, if yes, then check if the next rows are the related to the parent row then consolidate data according to your specification. These will be done in loop so the same process will be applied row by row (parent rows only). Please contact me if you are interested and is considering my offer. Thanks.
$5 USD 20日以内
5.0 (12 レビュー)
2.8
2.8
ユーザーアバター
hello , this cost is total cost as you seem want to pay one hour cost i completed many many tasks and i have about more than 118 reviews within 1-2 years with rating about 95% and level 4 ranking too and approximately 108 Projects completed and about 101 Buyers worked with so i would like if i helped you in your business and make future work too
$27 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Hello, thanks for taking the time to read my proposal. I would love to further discuss this project. If you have any questions I am here to answer them so please feel free to message me, or we can even schedule something over skype to chat. I pride my work on being professional, of the highest quality and always delivered on time. I am confident I can provide you top output that will fit your needs. I look forward to discussing this opportunity with you further. Best regards Vipul
$5 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
I am having 7 years experience in Excel VBA and Access, worked on several automation processes. I am confident that i can complete this within timelines
$5 USD 1日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
Δεν έχει γίνει καμιά πρόταση ακόμα
$3 USD 5日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

TURKEYのフラグ
Istanbul, Turkey
4.8
15
メンバー登録日:4月 11, 2013

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。