Hi Folks,
I hope that you can help. I am workign on an audit tool that I need to have some form of self check built in for specific parts of the worksheets.
I have atatched an example of what I am looking for but in brief If in Cell B2 there is a numerical value then I need cell C10 to have the value from C2, however if no numberical value then I need the cell to delete any text elements ie a space and leave the cell black.
I have also added the actual cells from the tool (Example 2) where if any of 3 cells in a row (B25:D25) contain a numberical value then the 4th cell (E25) must contain a numberical value, otherwise the cell must be blank.
I hope this makes any sense.
thanks in advance.
Copy of For James.xlsx
Bookmarks