Satisfying two variables entered via popup
 

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.

Satisfying two variables entered via popup
 

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.