Kamis, 23 Februari 2012

[ExcelVBA] Excel Macros

 

Hi friends..
Can anyone help me in write a program for macros with the following conditions..

I need to write a program in Macros that insert a value if the conditions matches..

say for example,

K(column name) = "BU Accessories" And AG(column name) = "APPAREL" And AM = "CCS" And AO = "Inline" And BL = "new" Then CE = "18 months"

that is IF all the above mentioned conditions matches with corresponding rows, then column CE should be automatically assigned to 18 months..

Looking forward for your reply..

regards,
Prabhu

__._,_.___
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar