Find Jobs
Hire Freelancers

Clean up VBA code in Scheduling Tool

$30-250 USD

已完成
已发布将近 6 年前

$30-250 USD

货到付款
I would like you to 1) clean up the code to provide the same functionality, but faster, 2) allow the user to select rows in the "bucket dates" tab so that they transfer to the correct worksheets without requiring them to copy and paste the sales order numbers to column A of each sheet. These sales orders drop off the list as soon as the order is fulfilled, or in other words, when the sales order no longer exists on the OORPT tab. The sales order data must always come from the OORPT tab, and not the bucket dates tab. 3) Any orders in the 4 main tabs that are past due show up at the top of the list and are highlighted yellow, 4) On the Wty Limbs tab, there is a Group Column at the far right (column Y). If Column X (Cust PO) contains "RA", RA1 must appear in column Y and increment up each time, in other words, if rows 3,4,5 contain RA in column X, Cell Y3, Y4, Y5, should say RA1, RA2, RA3, respectively. If the words "Prevail" or "ProForce" appear in the Special Inst Column (Col W), then the Goup Column cells should say T1, T2, T3, when they are scheduled. Any cell in the Group Column that is left blank must contain a unique letter each day, so A, B, C, D, etc..
项目 ID: 17235677

关于此项目

9提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Hi, Geoffrey! This is Paris Pallas. I place my bid after we've agreed on budget and time and we've set up the tasks required. I'm ready to work with you again on another promising project. Thank you in advance!
$150 USD 在7天之内
4.9 (268条评论)
7.6
7.6
9威客以平均价$182 USD来参与此工作竞价
用户头像
I can work for you. I'm interested in your project. I've an experience of works with ms excel and vba. Ping me any time to discuss about this project.
$155 USD 在3天之内
5.0 (10条评论)
5.2
5.2
用户头像
Hi, I can create a VBA code to process your excel file with multiple tabs as explained by you in the requirement document.I can start immediately and finish within 2 days. I will go with you till your requirement is 100% complete and you can count on me for future upgrades too. Please drop a message to discuss further.
$250 USD 在3天之内
5.0 (9条评论)
4.9
4.9

关于客户

UNITED STATES的国旗
Salt Lake City, United States
4.9
18
付款方式已验证
会员自2月 23, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。