Printable View
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!
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.
In the file, you have attached, in I sheet column c is not available thats it.:confused:
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!
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))
In C1:
=RIGHT(B1,10)
In C2:
=LEFT(REPLACE(B2,1,FIND("Date",B2&"Date")+5,"")&C1 ,10)
Copy down.