Is there a way to automatically change the value of all cells in a workbook (or with all open workbooks) with a default value "Date" with a date I want (not necesarily the current date). Please help. Thanks in advance.
Thats what I've been doing Replace. but is there a way to automatically do it, where i'll enter the date I want once and all the cells with a word "Date" on it automatically change. I have around 30 workbooks to change everyday. Thanks