Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |