I am new to VBA however not so new to Excel. I have coded before but as I do not know the language I have no idea where to begin. Here's the situation:
I have two sheets:
- Contains a list of jobs that are to occur with a Start Date, End Date, Status (In Progress/Completed/Scheduled) and Company Name (of the company performing the job)
- A Calendar of sorts with three columns: the previous month, the current month and the next month. Each row in this sheet represents a different day. I have attached an image as to what this sheet looks like. Sheet2, the Calendar
What I would like to Do
- I would like the calendar to be filled with the company names on the days jobs are being performed. So if the Jobs Sheet has data that says Company X is to be performing a job from Y Date to Z Date, I would like the calendar to say Company X for Y Date through to Z Date
- I would like each company name in the calendar to sheet to have a hyperlink to the appropriate row in the Jobs Sheet.
- I would like the font colour of the company name in the calendar to be different depending on its status, as stated in the Job Sheet.
My Problems
- I am unsure how to do this has there is only one cell for each day so if there are multiple jobs to be performed on the same day, would it be possible to have a hyperlink?
- I initially tried doing this using just formulas however the VLOOOKUP was only ever going to return the first match in dates it finds. As I mentioned earlier I have no idea where to begin when it comes to VBA.
I look forward to seeing all your replies and suggestions and thank you for taking the time out to read this looong post!
Bookmarks