Find Jobs
Hire Freelancers

Excel VBA Code Needed Calendar Mapping ASAP

$10-30 USD

Completed
Posted over 5 years ago

$10-30 USD

Paid on delivery
Please contact me if you are interested in the project below I have, I am a good colleague and will work with you. I need this done soon so please reach out if interested. Thank you-------- -----------------PROJECT DESCRIPTION: 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--------
Project ID: 18304389

About the project

1 proposal
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am a Data Entry Expert and proofreading with 15 years of experience. I also have experience in word, PowerPoint and excel. PDF to Word and Excel. My motive is to make my employer Happy without additional charges and time, so please, give a chance please.
$30 USD in 1 day
4.4 (58 reviews)
5.1
5.1

About the client

Flag of UNITED STATES
Falls Church, United States
5.0
1
Payment method verified
Member since Dec 6, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.