After insert new record, insert values in row based on first cell in row

[frankienap]

Hello all,
So I tried asking a related question yesterday, but I think I may have gone about my solution incorrecly. So instead I am going to try a new approach.

Description: I want to keep track of active clients (new and existing) during a several-step process. Some of these processes are shared across new and existing clients, and some are unique to the type of client. I currently use conditional formatting to distinguish between processes: Red ("1") means a process is necessary but not yet complete, Green ("0") means a process is necessary and complete, and Black ("") means a processess is unnecessary (i.e., it is unique to new but not existing clients and vice versa). Employees keep track of clients by changing the column value from red to green (i.e., replacing a "1" with a "0" from left to right) and after the last process is finished simply delete the record (row).

Goal: I want to be able to, when I add a new client, automatically insert 1's, and 0's based on the value of my first column (which IDs clients as either "New" or "Existing"). So after the value of Column A is changed (from blank to either "New" or "Existing"), 1s and 0s need to be inserted into particular columns within that row. Any help would be greatly appreciated.

My current columns look like this:

"Client Type" | Process A | Process B | Process C...

[frankienap]

Okay, I think I've made some progress. I think that I want to place the eventual code into the Worksheet_Change event for column A. Is that correct?

Now I just need help inputting 1s and 0s into cells in the same row based on the value inputted into the first cell (either "New" or "Existing"). Any help?

[arlu1201]

Is this request the same as http://www.excelforum.com/excel-2007...-and-sort.html ?