Checking cells for data, then ....

[Closed]
Report
-
Posts
13
Registration date
Wednesday November 3, 2010
Status
Member
Last seen
November 15, 2010
-
Hello,

hi i'm having a bit of trouble with something in vba and have tried searching but its complicated and i cant seem to find anything on it.

'working' worksheet - user enters general height anywhere between 2100 and 4600. sometime a second height is required which is sometimes the same as the general height.

'ground' worksheets - depending on the number/s entered cells need to appear with certain text
so cells that should appear depending on what is entered in the other 2...
if number in either cell is >= 1 and <= 2440, show
24*09
24*12
if number in either cell is >= 2441 and <= 2740, show
27*09
27*12
if number in either cell is >= 2741 and <= 3040, show
30*09
30*12

so if general height is 2440 and there is no other height or the heights are equal, show
24*09
24*12
but if general height is 2440 and other height is 2740, show
24*09
24*12
27*09
27*12

i can get it to work with just checking general height cell but when i add the other in it either doesnt show anything or it goes of the biggest number, eg if heights are 2440 and 2740 it only shows
27*09
27*12

grrrr frustrating hehe if anyone can shed some light it would be greatly appreciated

1 reply

Posts
13
Registration date
Wednesday November 3, 2010
Status
Member
Last seen
November 15, 2010
1
send your code of what you got, you just need to have multiple IF AND statements in your coding.