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

A

AdamsK

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
 
T

Tushar Mehta

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
 
Top