inserting date

[CORAL]

i dont know how explain my problem i just want excel file as sheet m from sheet l (changing sheet l to sheet m) please send me vba code
the date of height should be reapeted as you see in sheet m column c (in sheet l the date is as title so when i want to have max and min i cant get the date of it )
i think i explained very well!

[alansidman]

Please try to explain in simple English what you are looking for. Your file contains no explanation and my crystal ball is broken, so I don't understand what you wish to happen as the files show no correlation to each other.

[LalitPandey87]

In the file, you have attached, in I sheet column c is not available thats it.:confused:

[CORAL]

dont know how explain my problem i just want excel file as sheet m from sheet l (changing sheet l to sheet m) please send me vba code
the date of height should be reapeted as you see in sheet m column c (in sheet l the date is as title so when i want to have max and min i cant get the date of it )
i think i explained very well!

[rollis13]

Have a try (no VBA):
Copy this formula in Sheet l cell C1

=MID(B1,SEARCH("????/??/??",B1),10)

Copy this other formula in Sheet l cell C2 and then copy down

=IF(ISERROR(MID(B2,SEARCH("????/??/??",B2),10)),C1,MID(B2,SEARCH("????/??/??",B2),10))

[Scott Huish]

In C1:
=RIGHT(B1,10)

In C2:
=LEFT(REPLACE(B2,1,FIND("Date",B2&"Date")+5,"")&C1,10)

Copy down.