|Without knowing the layout of your spreadsheet, there's not much we can offer.|
You mention "drop downs" in your subject line, but there is no mention of drop downs in your post. You haven't given us very much to work with.
Perhaps if you posted some example data and tell us what you are trying to do with that data, we could offer some suggestions.
Before posting any data, please click on the following line and read the instructions on how to post data in this forum.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.