If cell = XX then.................
 

I am trying to create VB coding for the following, I hope someone ca
give me some direction, I am not very strong in thi
area................

Insert column before Column A
Name column "Club"
Insert club name based on info in column E
If last 8 chars =
michigan then assign MI to Column A
Nebraska then assign NE to Column A

Sort by column C(after above steps are complete)
by alpha, ascending

Subtotal - count column C

When the above steps are complete then
Based on column A
Move MI to New Sheet and name MI
Move NE to New Sheet and name N

--
Message posted from http://www.ExcelForum.com