Hi

I'm trying to satisfy two criteria via variables entered through popups.

Essentially , I need a routine that finds a criteria in one column and
matches it with a second column. Having identified the two , a further
popup replaces the criteria in the second column.

It would be something like this :

1st Popup requests a column
2nd popup requests a value within that column

3rd popup request a second column
4th popup requests a value within that column

5th popup requests a value to replace the value from popup 4.

These might be the choices :

B
Open

G
7.50

8.50

Indicating that where the word 'Open' appears in column B , and for each
time it has a value of 7.50 in G in the same row , then replace the 7.50
with 8.50.

Can someone help with this?

I'm grateful for any help.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Colin Hayes" wrote in message
...

Hi

I'm trying to satisfy two criteria via variables entered through popups.

Essentially , I need a routine that finds a criteria in one column and
matches it with a second column. Having identified the two , a further
popup replaces the criteria in the second column.

It would be something like this :

1st Popup requests a column
2nd popup requests a value within that column

3rd popup request a second column
4th popup requests a value within that column

5th popup requests a value to replace the value from popup 4.

These might be the choices :

B
Open

G
7.50

8.50

Indicating that where the word 'Open' appears in column B , and for each
time it has a value of 7.50 in G in the same row , then replace the 7.50
with 8.50.

Can someone help with this?

I'm grateful for any help.