Compare Date - Overwrite value

[Mrs.Bala]

Hello everyone,
First of all sry for my bad english. I hope you understand me anyway.
I have got a big problem i have been struggling around for some time now and i hope you can help me.

I have different products with different state; but some of them are not correct and i want to overwrite them.

In column A my products are listed.
In column A to K have Information about the product.
In column M to AQ i have for every day the last state of the product.
(example:
M1-01.01.2011: delivery
N1-02.01.2011: reserved
O1-03.01.2011: sold)
In column K i have the last state of the product (example: sold, lost, damaged)
In column J there is the date when the product changed to this state.

My aim is to put the balue which is written in J, based on the date of column K, in the corresponding date in the column from M to ... . All entries after this date should also have the same value.

I hope you understand my problem and can help me. If there are some problems at understanding i will try to rephrase my question.

Thank you very much!

 

[pbornemeier]

Welcome to the Board!

Does M1 contain the data value and the status?
Can the date in M2 be different from the date in M1?
For the data you showed, would P1 contain
04.01.2011: sold
would AQ1 contain 31.01.2011: sold
does j or C contain the date. This shows a contradiction:

In column K i have the last state of the product (example: sold, lost, damaged)
In column J there is the date when the product changed to this state.

My aim is to put the balue which is written in J, based on the date of column K, in the corresponding date in the column from M to ... . All entries after this date should also have the same value.

 

[Mrs.Bala]

Hi!
Thank you for your answer. And sorry for my late reply.
I friend of mine helped me to solve the problem.
Thank you very much for your reply though

Nice Forum...I will return here more often...although i should practice a little bit more VBA

Nice Day!