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.