Hello,
i am running EXCEL 2007.
i am trying to make an if statement that accomplishes something like, If c1=b1 then d1 = pick a choice from the data validation list(drop down list) that is from e1 to e5. else pick a choice from the data validation list(drop down list) that is from f1 to f5.
i am new to running macros in excel. pls advise how i need to insert a macro for a particular cell and then copy it to the other cells below it i.e for d2,d3..etc to chk for c2,c3,..etc
thanks
Configuration: Windows XP Safari 530.5
Am not sure whether I have understood your question correctly
|
Data validation from one sheet to another in excel Excel 2007 vba data validation Excel if a1 is uppercase then Excel if functie color red Excel if function change text colour 2003 Excel if function using output of if function in another cell Excel macro split data into different sheets Excel macro textbox if len 31 validate How can download data in excel if rows are more How to use two condition in if function in excel How to write macro in excel to copy data from one sheet to another If function excel 2007 formula for true If function in excel 2003 If functions comparison in excel If functions excel 2003 color coded cells Macro vba to hide columns with if function Microsoft excel if function time Use excel if function to select which list to show