I viewed your video on how to do this and I used the code and created a macro and it works great on my worksheet. However i want the same to work on the multiple sheet in the same workbook. Please advice on this. For example i have 10 sheets(might add more) in a workbook in each sheet i have 10 colums and 11 and 12 is date entered and date modified.how do iĀ have date enteredĀ and Date modified in column 11 and 12 in all the sheets.