Add comment in column if

Hi all

I need to create a list of open items each day

In cell A2 the "as of date" is written. So e.g. tomorrow i'll make the list as of 1st October 2012 (it's entered in a proper excel date format), today its as of 28th September 2012

In the list of open items the date is in col C
After five working days from the as of date a comment for the item should be mandatory.
Therefore i'd like to add this in a dedicated col. (e.g. col L)

So i figured following code should

Please Login or Register  to view this content.

But it doesnt work.

I know, I know... if formula would work - but theres other stuff linked to this - so it would make it easier if these items were updated automatically.

Anyone who could hep out?

Office 2007

Hi buran

I tried your code, but it did not do what i expected

basicly i need to follow open items - in this list if a line is older than 5 days a comment is mandatory

In cell A2 always the last working date is entered (as of reference date)
in col. C you can see the date the items has first been pending.

So, if A2 as 25th Sept. 2012
and C5 has 24th Sept. 2012
so the diff is 1 day and no comment needed.


So, if A2 as 25th Sept. 2012
and C6 has 17th Sept. 2012
so the diff is 8 days and comment is mandatory (in col. o) - so in col. P the word "COMMENT" should pop up.

as I said, i could do it with formulas, but you know how it is - not properly copied by the user, etc, etc...

No, sorry, I didnt...

OK great... that works
quick question: if you disable screenupdating, does it update anyway? I have never experienced this before...

Hi buran

That's what I meant - but for me the screen updates nonetheless.
I never saw this before, any idea?

stupid me... i should disable events ;-))

quick question: how would I intergrate this in a worksheet change, rather then a macro, which will run manually?

Thanks

Hi

Thanks - I actaully tried just that

I've extended my code in the meanwhile

Please Login or Register  to view this content.

when i run the code as a single macro it works pefectly

but when its on worksheet_change it ends in "Method 'Value' of object 'Range' failed"

Any idea why this would happen?
Thx

Perfect! Helped me a lot

Thanks