Hi, I'm quite new to VBA and am struggling with what I thought would be a relatively basic idea. I want to create a macro that will take a given cell value and find the corresponding cell of the same value in another worksheet. In essence I just want a simple find function that uses a cell value rather than a manually typed text string.
What I have is a callendar sheet and I want users to be able to select a particular date and the macro will look in another (activities) sheet to find the entry for that date.
Can anyone help?
Bookmarks