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

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

I'm sure you know what you are doing, but some of the stuff you are
trying to do doesn't even make sense to me (the part about counting
column C, for example).

Nonetheless, consider using the macro recorder to get the necessary
code. Turn it on (Tools | Macro Record new macro...), use the GUI to
do whatever it is you want to do, and turn off the recorder. XL will
-- with a few exceptions -- give you the necessary code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , AdamsK
says...
I am trying to create VB coding for the following, I hope someone can
give me some direction, I am not very strong in this
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 NE


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