Date to be placed into Column "C" with matching value in Column "B" in same row

C

Corey

I have in Sheet1.

B17 = January 07
B18 = February 07
...
...
B28 = December 07


These Months/yrs are in range("B17:B28").

How can I have the current Month and Year placed into the cell to the Right of the matching Month and Year.
IE. Range("C17:C28") ?

If January 07 is in B17 then C17 is to have "Now( ) mmmm yy" placed in it by code when "Now ( )" is January 07 etc....

I want this to occur at the end of running a macro in another sheet, but cannot figure out how to get it placed in the right cell along side of the B Column value.



Corey....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re : Date to be placed into Column "C" with matching value in Column "B" in same row 1
Matching Value placed in next column 1
Now() to be placed in Next Column ? 1
Matching a Month Year value 0
Check for values in column A and if found then column B must have value. 3
please help me format this date to Month and Year 4
match one column with dates to several colums with dates, copy pas 4
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2

Top