Dear Friends,

I know VB programming & also knew that excel macro includes VB codes. But I
don't know how to select cells ad how to check a data in a particular cell
and inputing a data to another cell w.r.f to the checking cell.

I'm using excel 2003.

Example:

A B C D E F G H I J K L M N
O
1 - - - - - - - CA NS N - - - CANS
2 - - - - - - - CA WIP N - - - CAWIP
3 - - - - - - - CA C N - - -
CACMPD
4 - - - - - - - CA C Y - - -
CRRCVD
5 - - - - - - - RO NS N - - - RONS
6 - - - - - - - RO C N - - -
ROCMPD
7 - - - - - - - RO C Y - - - RORDY

We are doing telecom cell site project. Let me explain about the sheet snap
i mentioned above.

H column states the acceptance status of the site. This will have 3 status
viz. C - Cleared, CA - Conditionally Accepted, RO - Reoffered.
I column states the Pending jobs status. This will contain 3 status NS - Not
Started, WIP - Work In Progress, C - Completed.
J column states Ready for Reoffer or Compliance Report received.This will 2
status Yes or No.

Now the scenario is that if the site has been Cleared, then no issues.

If the site is CA, then the pending job has to be compelted and a Complaince
Report to be submitted stating that the pending job are done.

If the site is RO, then pending jobs to be completed and it has to be
reoffered for another visit to client.

If H = C, then no chekcking, direclty putting N = Cleared.
If H = CA and I = NS, then O = CANS, that means site is Conditionally
Accepted and pending job clearance Not Started yet.
If H = CA and I = WIP, then O = CAWIP, means pending jobs clearance Work In
Progress.
If H = CA and I = C, then O=CACMPD, means site is CA and pending jobs
Completd.
If H = CA and I = C and J = Y then o = CRRCVD, means Compliance Report
received.

Same case for H = RO,except the last one if H = RO and I = C and J = Y, then
O = RORDY.

I have done this with nested IF formula but it supports till 7 if conditions
only.

So, kindly anybody help me out by giving some tips how to select the cells
and it s values in a particular sheet or somethign like this.

If you are unable to understand what I want to say then feel free to contact
me on my emil id . I'll email you the worksheet itself.

Thanks in advance
Sriram