Group,
Lets say I have two columns, in column A I have state names like Illinois, Indiana and Iowa. Lets also say in column B I have numbers. How can I select a range of cells containing numbers for Illinois. The states will be continuously used. In other words, all the Illinois cells will follow each other, then right after the final Illinois cell an Indiana range of cells will be continuous and so forth. On any range selection, I'm only selecting one state at a time. Your thoughts how I can overcome this problem.
Thanks again for all your assistance........
Tony
Bookmarks