Here is the scenario:
New cases are entered on to the spreadsheet. The case remains empty until a date is entered, at which point the cell turns to Contract, Temp or Perm. What I need is the following:
Cell E2 = should say BLANK if there is no value in cell (Date YTD) J2.
Cell E2 = should say "Contract, Temp or Perm" if a date or any value is entered in cell J2. In Cell D2 it will show if the job post is "Contract, Temp or Perm" - So as soon as a date is entered in J2, E2 should confirm what Cell D2 says. So if D2 says Temp, E2 should say Temp.
Please bear in mind I have very limited knowledge of Excel and no working knowledge of VBA, so will need any instructions you are able to provide in basic language.
Thank you so much for your time.
Bookmarks