Problem setting range in macro based on todays date.

Hi Guys,

I'm hoping theres a fairly simple solution to this one, I'm pretty new to VB though have used excel for a long time but I can't get my head around how to do this.

Essentially what I want is a sheet users will use that will have 2 buttons, Emails received and Emails completed. Everytime they receive an email they click a button and a value in a cell on a differant sheet increases by one.

I have been able to to do this using simple Macros : -

Please Login or Register  to view this content.

But my issue is the data range, at present when clicked the value is written to cell C5 and D5. However, what I am after is a VLookup of sorts that will write to the cell based on the date in column B:B. In column B is a list of dates from today onwards, today being in B5, therefore when I press the button I want the data to be written to C5 and then tomorrow D5 etc.

So over time I would end up with a table like the following: -

Date Emails R Emails C
14/09 4 3
15/9 5 2

Thanks in advance!

Edit:
Title is best I could think of to describe problem!

Welcome to the forum.
Please wrap ur code .. see forum rules

Double post

You have stumbled into a moderated forum.

Please take a few minutes to read the forum rules, edit your post to add CODE tags (not QUOTE tags), and amend your thread title to describe your problem.

Thanks.

Maybe like this (untested):

Please Login or Register  to view this content.