I am using Excel 2002 and have a spreadsheet comprising columns A – AM and rows 1-900
Entries in column O can be C, N, RC, RN
I have been trying to write a code so that –
If Columns O = C and J is a date in the future, then Column C will automatically be populated with “CW” and the whole of...