Find Jobs
Hire Freelancers

Excel VBA Code Needed Calendar Mapping (Urgent)

$2 CAD / hour

已完成
已发布超过 5 年前

$2 CAD / hour

I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Comments". Once someone has organized the columns into the standard format of those columns above, they should go to a main tab labeled "INPUTS". This tab should have a section named "Key Dates" to add a "Start Date" and an "End Date" (both US and labelled) with a section also named "Key Contacts" (Also Labelled). In this "Key Contacts" they should be able to enter 1-10 different names or phrases. Once someone has populated the key contacts and the key dates I should be able to hit a button labeled "Get Deal Alerts" to run a VBA a code. The VBA code in the button should be able create a new tab labelled "OUTPUT". This "Output" tab should be a calendar. This calendar should finds rows that are in-between and include the range between the "Start Date" and "End Date" from the "Key Dates" section in "INPUTS". In addition to populating from the range of two diffrent dates, the code should also pull rows in the range listed in "Key Dates" that match the names or phrases listed in the section named "Key Contacts" on the "INPUT" tab. This "Output" tab should be a calendar that maps first the dates in the "Key Dates" but also the "Key Contacts" that are listed and are within the populated date range. The output can be in a nice professional office format with light colors I am not picky. Anyone trying to use the workbook should be copy and paste the external calendars as tabs in the format "Deal Name", "Task & Description", "Key Date", "Organizer", and "Comments" and add the dates to get the "OUTPUT" file. ----------- Please Contact if you can create this and send me samples to test for accuracy and usefulness-------- (Sorry for Payment / Milestone)
项目 ID: 18304788

关于此项目

2提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
Possess expertise in Advanced Excel, VBA Macros. ·         Developed effective Dashboards using Tableau/Microsoft Power BI and VBA Macros ·         Having knowledge in SQL. ·         Used SQL Queries to update and Retrieve data from MS Access.
$2 CAD 在2天之内
0.0 (0条评论)
0.0
0.0
2威客以平均价$2 CAD/小时来参与此工作竞价
用户头像
Kibriya Here. I have been working as a freelancer for more than a year. I always try to give my 100%. So If you need any work I'm always available here. Just drop a message and I will be there for you.
$2 CAD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

PAKISTAN的国旗
Okara, Pakistan
4.8
31
付款方式已验证
会员自8月 4, 2016起

客户认证

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