Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Some sort of a For Each loop??
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 -- DejaV ----------------------------------------------------------------------- DejaVu's Profile: http://www.excelforum.com/member.php...fo&userid=2262 View this thread: http://www.excelforum.com/showthread.php?threadid=38623 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Setting up some sort of cutting and pasting loop | Excel Worksheet Functions | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
Worksheet_Change - loop within a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |