i have column h with address number
i have column k with street name
in column iv i have an x an number or it is empty
what i want to do is press a button and it starts at iv10 read that cell if empty then read iv11 ect
when it reads x in the cell then read next witch will be a number
example
iv10
iv11
iv12
iv20 x
iv21 21
so i would get columns a - ae and rows 10 - 21 displayed and wait till i press button again
then when i press button it starts
example
iv22
iv23
iv89 x
iv90 68
then it would display a-ae 22 - 90
anyhelp anybody
thanks all
i have column k with street name
in column iv i have an x an number or it is empty
what i want to do is press a button and it starts at iv10 read that cell if empty then read iv11 ect
when it reads x in the cell then read next witch will be a number
example
iv10
iv11
iv12
iv20 x
iv21 21
so i would get columns a - ae and rows 10 - 21 displayed and wait till i press button again
then when i press button it starts
example
iv22
iv23
iv89 x
iv90 68
then it would display a-ae 22 - 90
anyhelp anybody
thanks all