Re: $$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread Gaurav Garg
find the formula closing date Fiscal Period1-Jan-12 Q1-2012 =+IF(MONTH(B6)=3,Q1,IF(MONTH(B6)=6,Q2,IF(MONTH(B6)=9,Q3,IF(MONTH(B6)=12,Q4,-YEAR(B6) 2-May-12 Q2-20125-Sep-12 Q3-20126-Oct-12 Q4-2012 1-Jan-13 Q1-2013 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread Gaurav Garg
Hello Friends, ** ** Does anyone have training material on VBA? Could you please share. ** ** In case if anyone knows about any good site for the same please share link.* *** ** ** Best Regards, GAURAV GARG ** On Tue, Jun 11, 2013 at 4:03 PM, కిరణ్ కొత్తకోట kothakota.ki

Re: $$Excel-Macros$$ How to Use Conditional SUMIF

2013-04-17 Thread Gaurav Garg
options, visit https://groups.google.com/groups/opt_out. -- *GAURAV GARG* *Asstt. Manager* *Retail Finance* *IITL-NIMBUS GROUP* *Mob.- 09717507227* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum

Re: $$Excel-Macros$$ For one workbook to another workbook

2013-03-08 Thread Gaurav Garg
Dear Experts i have one sheet in this sheet there is a hyperlink , i want that it should be blink. it may possible through by VBA coding.can anyone help me for solve this problem . *GAURAV GARG* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna