Need to find a date and if fount replace and if not make new line

Hello,

I have a problem with finding a code,

I have a sheet (call "Blad") with a date in "F2" and in A5:A8 information

nou i whant the second sheet ("data") in this sheet is the first colum the dates en de 2nd till 7th the information

now i whant if the date in F2 the same is as in the data sheet he replace the information behind that date
if the date is not exist he must make a new line

hope someone can help me thanks

Not sure, but see if this helps?

Please Login or Register  to view this content.

Thanks John,

something like this but why he can not find or write the date?
and if i put numbers in it it write only once how is that possible.

Originally Posted by Tom1687

Thanks John,

something like this but why he can not find or write the date?
and if i put numbers in it it write only once how is that possible.

I'm only guessing. Perhaps you should take the suggestion given by Mumps1, so we'll know exactly what you're trying the achieve.

Yes but jou dit it on the corrects sheets john so i do not understand what mumps1 means

the firts sheet (Blad) are the information what i put in
de second sheet (Data) must be the database

en the informtion what are in the file what he asks

When I tested it on your sample, it found the date. But I'm not sure the pasting is what you want.

if i test the date i don't work

i put another example with better explanation i hope