Need Help With Calendar

[jgbiii]

I am creating an outlook style calendar and I need help with a pair of functions. Attached are some screenshots to help with a potential solution.

Problem 1: Main issue is that I need to be able to click on any cell in row F of the first page (under video name) and have the "video details" in the field to the right (column P, first page) populate with text. This text comes from page 3, which is a set of data validation.

Problem 2: I need to have worksheets 1 and 2 open to whatever day it is automatically.

Any help is GREATLY appreciated.

Page 1:
screen 1.jpg


Page 2:
screen 2.jpg


Page 3:
Screen 3.jpg

[daffodil11]

I'd utilize a little bit of VB code to update the Activity and Details on selection change.

Standard formulas could be used to dynamically fill in the calendar date with use of Today().

VB Code I used:

Please Login or Register  to view this content.

Example is attached.

[jgbiii]

Daffodill 11 -

Attached is a better screenshot of the first page - I noticed your example didn't have a key component of my calendar that was left off my original screenshot.

The gist of it is that when I enter a date in D4 (enter date field), it pulls up the daily itinerary from the 'schedule input' workbook using a HLOOKUP.

I have never worked with VB code, but I will simply google that and figure out if I can simply copy and paste that code somwhere. Although I assume that the code will change with this new bit of information I have given you.

Untitled.jpg

[daffodil11]

Not much, really. You'll just be looking up D4 instead of using TODAY().

The VB code would need to be adapted for differences in range, but otherwise it would all be the same.

[jgbiii]

Not sure I understand what to to do here - in fact I'm positive I'm lost.

I've copied and pasted this code into Microsoft Visual Basic for Applications into a "module" based on some rough instructions. Nothing appears to change once I do that.

I also don't see where in your code the phrase "Today ()" appears, so I don't know how to change that to D4.

Lost,

[daffodil11]

Sorry, I've been away in Access programming class.

The formula I provided in cells F9:F25 in the attachment have formulas dynamically provided the correct date's agenda. Instead of referencing TODAY() in the nested MATCH, you'd reference D4.

Please Login or Register  to view this content.

becomes

Please Login or Register  to view this content.