I need Excel Vba code in excel for a following task.
Two w/books >first w/book -- ABC.xlsx >sheet1> Sheet1(A2) > has date value> if this value occurs in > second w/book--TKR.xlsx>sheet1>
search in entire Column B>If the date value exists> message>"Date already exists">Exit Sub> If date value not exists> do something else code.
both w/books are not opened. Location of 2 w/books>C:\Raju\My documents. I am using windows11> office365
Two w/books >first w/book -- ABC.xlsx >sheet1> Sheet1(A2) > has date value> if this value occurs in > second w/book--TKR.xlsx>sheet1>
search in entire Column B>If the date value exists> message>"Date already exists">Exit Sub> If date value not exists> do something else code.
both w/books are not opened. Location of 2 w/books>C:\Raju\My documents. I am using windows11> office365