Wierd data into combo box
Posted by Phil Leaper on February 09, 2001 9:03 AM
Hi, I'm in a bit if strife and I was wondering if anyone could help.
I have a 3 sheets in my workbook, one of which is called Suppliers which contains a list of company addresses spaced exactly 9 rows apart (5 lines of address and 4 of space)(I don't know why they did it like that, but there are too many entries to change easily). I need to get the first lines of each of the addresses into a combo box in a sheet called Input. How do I state 'only retrieve every 9th row', in macro form, and how do I populate the combo box with the returned data