Fwd: $$Excel-Macros$$ Income Statement Review Macro

Hello Sir, Can you please help me. Thanks, Nilkanth Raval. -- Forwarded message -- From: "Nilkanth Raval" Date: Feb 28, 2015 2:04 AM Subject: $$Excel-Macros$$ Income Statement Review Macro To: , "Vaibhav Joshi" Cc: Dear Sir, I want to write a macro for IS Review. In attache

$$Excel-Macros$$ Query in IF formula on sheet deactivation event

Dear expert, I need help in attached file in which if cheque amount is greater than zero and date & cheque number field Blank then msgbox should display, and when cheque amount is blank, no any msgbox should display. In my case and as per my formula the msgbox display even cheque amt. field is ze

Re: $$Excel-Macros$$ Function for Data validataion

Hi Mr.Paul I make below condition to check first four character is Alphabetic. =AND(LEN(B8)=11,ISNUMBER(INT(RIGHT(B8,7))),CODE(LEFT(B8,1))>64,CODE(LEFT(B8,1))<91,CODE(MID(B8,2,1))>64,CODE(MID(B8,2,1))<91,CODE(MID(B8,3,1))>64,CODE(MID(B8,3,1))<91,CODE(MID(B8,4,1))>64,CODE(MID(B8,4,1))<91) Could yo

$$Excel-Macros$$ Help Needed

Dear Friends Pls find attached file of my work In sheet two sheets one is main sheet & another is daily data in main sheet yellow mark is the difference of two dates i want to do this automatic becuase @ present i do it mannual and its taking too much time pls give me suggestion Warm Regards,

$$Excel-Macros$$ Re: Function for Data validataion

Dear Ashish, Following should solve the issue AND(ISNUMBER(--RIGHT(B8,7)),LEN(B8)=11,(ISTEXT(IFERROR(VALUE(MID(B8,1,1)),(MID(B8,1,1),(ISTEXT(IFERROR(VALUE(MID(B8,2,1)),(MID(B8,2,1),(ISTEXT(IFERROR(VALUE(MID(B8,3,1)),(MID(B8,3,1),(ISTEXT(IFERROR(VALUE(MID(B8,4,1)),(MID(B8,4,1))