Auditing excel sheets for everyday task

T

test

Greetings,

We have excel sheets created everday for some tasks. Each task in
excel is assgined one of the 3 values: SUCCESS, FAIL or OTHER. There
are 3 columns that are getting filled manually.

ColumnA: Filled with either SUCCESS, FAIL or OTHER
ColumnB: If the columnA is filled with either FAIL or OTHER, then the
column B should be filled with reason for these values. So in short ,
if ColumnA's value is either FAIL or OTHER, then ColumnB should NOT BE
NULL.

Is there a way to achive this? Also, I have to make sure that ColumnA
should be happing anythng else other than SUCCESS, FAIL or OTHER
values.

For now, we are doing this manually. But we have lot of excel files
and each one has pretty big data. I want to achieve this using a code
to avoid manual work.

Can anyone please advise.

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auditing excel for everyday tasks 6
Excel Updation 5
Publisher is filling blank lines with data 2
Formula Audit mode active in one column only; cannot kill. 2
Auditing Excel sheet - Message Box on exiting excel 4
Excel 2010 Conditional Formatting 2
Querying master worksheet 1
lookup needed to give value where the lookup value is a string within a cell. 2

Top