Some sort of a For Each loop??

[DejaVu]

I have a column that contains various strings. Example:
Sales
Price
Figures
Trade
New
Old

I want to do some sort of procedure that finds all the variations i
this column. For example, say the above is my data for this month
then it would create six string variables (one for each: "Sales"
"Price", etc..).

If my data next month was:
Sales
New
Old
Then it would create three string variables ("Sales", "New", "Old").
What I eventually want to do is take all the variations, and copy th
rows to their own worksheet (take all "Sales" from my master sheet an
move to a newly created "Sales" sheet). I think I can accomplish thi
second part, if I can find a way to figure out all the variations t
start with.

I'm not sure If I can explain this in a better or more clear way, bu
if you need more explanation, I can try.

TIA for all help!

DejaV

 

[Tom Ogilvy]

Go to Ron de Bruin's site. He has already written the macro to do the
copying:

http://www.rondebruin.nl/tips.htm