I have a small spread sheet where I have names in column A and various values
in columns B thru H. I need to select a value from column B, have excel
extract the data and copy and sort the names to a new column or worksheet.
I've tried Vlookup and lookup but can't get them to work right.

Is this something I'm going to have to learn VBA to do?

Thanks in advance,
Graycoast