code that will check the date from a table if its MM/YY is current and if not then date=YY

[richzter]

When Year in Year/month column is current then retain Year/Month value, if year in Year/Month column is prior year then Year/Month2 = Year.

Year/Month	Year/Month2
2014/May
2013/april
2014/jan

[:) Sixthsense :)]

When Year in Year/month column is current then retain Year/Month value

Not sure what do actually mean by the word retain

[richzter]

Not sure what do actually mean by the word retain

sorry.. it means that if the yy/mm is current then Year/Month=yy/mm

[richzter]

if the 1st column is 2014/May then 2nd column is 2014/may
if its 2013/june then 2nd column is 2013

[:) Sixthsense :)]

Your condition part is very clear in your first post itself but wants to know the action part only...

[richzter]

Your condition part is very clear in your first post itself but wants to know the action part only...

im sorry what do you mean by action part?

[:) Sixthsense :)]

Better show the expected result for Year/Month2 column for the given examples for giving exact solution

[richzter]

Year/Month	Year/Month2
2014/May	2014/May
2013/april	2013
2014/jan	2014/jan

uhmm.. if i may add.. do you know a code that will not rely on the cell name? but for the column name or ranges.. so that if the user suddenly enters another column.. the codes wont be rendered useless..

[:) Sixthsense :)]

Don't know the real need for VBA here... what about a simple formula solution?

In B1 Cell

=IF(LEFT(A2,4)=TRIM(YEAR(TODAY())),A2,LEFT(A2,4))

Drag it down...

[richzter]

Don't know the real need for VBA here... what about a simple formula solution?

In B1 Cell

=IF(LEFT(A2,4)=TRIM(YEAR(TODAY())),A2,LEFT(A2,4))

Drag it down...

yeah thanks.. but what if the user suddenly adds a column...

[:) Sixthsense :)]

yeah thanks.. but what if the user suddenly adds a column...

The target cell will not get changed and it will target the source cell always.

If you want to set it to a new column then just change the source column name (in the formula) to your newly created column.

Pleaes let me know if you want something else...

[richzter]

The target cell will not get changed and it will target the source cell always.

If you want to set it to a new column then just change the source column name (in the formula) to your newly created column.

Pleaes let me know if you want something else...

uhmm.. 1 last thing.. can you explain how it works?

[richzter]

The target cell will not get changed and it will target the source cell always.

If you want to set it to a new column then just change the source column name (in the formula) to your newly created column.

Pleaes let me know if you want something else...

please explain how it works.. so i know how to use it next time.. thanks