I have a worksheet with 100 rows from 7-106 that I want to include and three
columns S, AC, AI that I want to use for this formula or macro.( I have
other data in the other cells)
If S7 has a "Y" and I insert a "Y" in AC7 I would like "Y" from S7 to be
removed. If I insert a Y in AI7 I would like AC7 to be removed.
In other words There should only be one y in either cell mentioned for that
row.
I would like all 100 rows to have the same function but not effect other
rows. If I insert a y in cell AI7 I want S7 or AC7 to have a y removed, S8
or AC8 should not be effected unless I insert y in that row.
I hope I made myself a little clearer. Is this even possible to do?
Thanks so much in advice
Digital2k

Pls do NOT multipost. We read em all. See answer in your other post.

--
Don Guillett
SalesAid Software

"Digital2k" wrote in message
...
I have a worksheet with 100 rows from 7-106 that I want to include and
three
columns S, AC, AI that I want to use for this formula or macro.( I have
other data in the other cells)
If S7 has a "Y" and I insert a "Y" in AC7 I would like "Y" from S7 to be
removed. If I insert a Y in AI7 I would like AC7 to be removed.
In other words There should only be one y in either cell mentioned for
that
row.
I would like all 100 rows to have the same function but not effect other
rows. If I insert a y in cell AI7 I want S7 or AC7 to have a y removed, S8
or AC8 should not be effected unless I insert y in that row.
I hope I made myself a little clearer. Is this even possible to do?
Thanks so much in advice
Digital2k

OK Don,
Thanks for your help,
It works great until I insert a Y in the AI column, the entire excel program
locks up I have to Ctrl, Alt Del to end program. the other columns work
great. Any clues on what's causing this problem?
Digital2k


"Don Guillett" wrote in message
...
Pls do NOT multipost. We read em all. See answer in your other post.

--
Don Guillett
SalesAid Software

"Digital2k" wrote in message
...
I have a worksheet with 100 rows from 7-106 that I want to include and
three
columns S, AC, AI that I want to use for this formula or macro.( I have
other data in the other cells)
If S7 has a "Y" and I insert a "Y" in AC7 I would like "Y" from S7 to be
removed. If I insert a Y in AI7 I would like AC7 to be removed.
In other words There should only be one y in either cell mentioned for
that
row.
I would like all 100 rows to have the same function but not effect other
rows. If I insert a y in cell AI7 I want S7 or AC7 to have a y removed,
S8
or AC8 should not be effected unless I insert y in that row.
I hope I made myself a little clearer. Is this even possible to do?
Thanks so much in advice
Digital2k

see ans in OTHER thread

--
Don Guillett
SalesAid Software

"Digital2k" wrote in message
...
OK Don,
Thanks for your help,
It works great until I insert a Y in the AI column, the entire excel
program locks up I have to Ctrl, Alt Del to end program. the other columns
work great. Any clues on what's causing this problem?
Digital2k


"Don Guillett" wrote in message
...
Pls do NOT multipost. We read em all. See answer in your other post.

--
Don Guillett
SalesAid Software

"Digital2k" wrote in message
...
I have a worksheet with 100 rows from 7-106 that I want to include and
three
columns S, AC, AI that I want to use for this formula or macro.( I have
other data in the other cells)
If S7 has a "Y" and I insert a "Y" in AC7 I would like "Y" from S7 to be
removed. If I insert a Y in AI7 I would like AC7 to be removed.
In other words There should only be one y in either cell mentioned for
that
row.
I would like all 100 rows to have the same function but not effect other
rows. If I insert a y in cell AI7 I want S7 or AC7 to have a y removed,
S8
or AC8 should not be effected unless I insert y in that row.
I hope I made myself a little clearer. Is this even possible to do?
Thanks so much in advice
Digital2k