Seperating Data

[Bob1980]

Hello All,

This forum has been great, I've been learning a lot about VBA. I have a new question.

I don't know how to describe the object models that I need to use, so I'll just describe what I am trying to do.

I want to list the different names of data from a list of data. there could be anywhere from 1 - 64 sets of data. Each set of data can be differentiated from one another by the "Name" (column B) of the test, which is before the hyphen("-"). Here is where it gets tricky, the name of the test before the hyphen will always change. I think that if a list of the different test names can be listed, then I can create some formulas within the worksheet (non-vba), to pull the data from the existing table.

Does this make sense? I've attached a sample copy of the data, in the format that it will be in an excel tab.

Thanks,
Bob

[tigeravatar]

Bob1980,

To make sure I'm understanding you correctly, do you want the result to be this list (using your posted Sample Sheet)?
111A
222B
Iron

If so, where does that resulting list go? In a sheet of its own? In a specific column? Would you prefer formulas only or a macro or does it not matter?

[mike7952]

Give this a try. Will add the results to sheet2

Please Login or Register  to view this content.

[Bob1980]

Hi Mike,

Thanks for the help. I had to add

Please Login or Register  to view this content.

, but other then that; the code worked like a charm. I'll get going and start parsing this so I can see what's going on. thanks again!

Bob

[mike7952]

Ah I forgot the dim i. Should be dim i as long