C
Colin Hayes
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.
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.