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(E

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, కిరణ్ కొత్తకోట wrote: > h

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

2013-04-17 Thread Gaurav Garg
egroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- *GAURAV GARG* *Asstt. Manager* *Retai

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