I am not very well versed on Excel but find it a very powerful tool. Can
anyone suggest how I can do the following?

In a workbook, I am using sheet one as my main entry page. In column b I
have a drop down menu in each cell that lets me choose one of four alpha
strings. I want to (possilbly a macro) have excel read this column, sort by
alpha string in column b, then copy and paste each row (less the cell in
column b) to its own worksheet in this book which will be titled the same as
the string it identifies. Thus if column b has "acme" listed in row 7 I
would like it to copy cells 7a,7c-7f to sheet 3 which is named "acme" and
have this new entry pasted into the next available row (no overwriting). Can
anyone help as I am not very educated (yet) with excel functionality???

Thank you!!
--
Rockhound

First, I would try to keep my data in that one worksheet. I could use
data|Filter|autofilter to show/hide the stuff I want seen or hidden.

You may want to look at the way Ron de Bruin and Debra Dalgleish approached it:

Ron de Bruin's EasyFilter addin:
http://www.rondebruin.nl/easyfilter.htm

Code from Debra Dalgleish's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

All of these samples copy the entire row (if I recall correctly), but maybe you
could modify the code or even delete columns after it's done.

Rockhound wrote:

I am not very well versed on Excel but find it a very powerful tool. Can
anyone suggest how I can do the following?

In a workbook, I am using sheet one as my main entry page. In column b I
have a drop down menu in each cell that lets me choose one of four alpha
strings. I want to (possilbly a macro) have excel read this column, sort by
alpha string in column b, then copy and paste each row (less the cell in
column b) to its own worksheet in this book which will be titled the same as
the string it identifies. Thus if column b has "acme" listed in row 7 I
would like it to copy cells 7a,7c-7f to sheet 3 which is named "acme" and
have this new entry pasted into the next available row (no overwriting). Can
anyone help as I am not very educated (yet) with excel functionality???

Thank you!!
--
Rockhound

--

Dave Peterson