WORKBOOK 1.xlsx
WORKBOOK 2.xlsx
Hi, I am new to this forum and my knowledge of excel is very basic. I have to workbooks. I wish to enter a date in a cell in workbook (2) but if it does not match the date in a nominated cell in Workbook (1) I require it to return an error message in workbook (2 ).
Can this be done?