Re: $$Excel-Macros$$ Periodic Formula help

2013-10-02 Thread Avinash Patil
Awesome man it's working thanks a TON! Regards, Avinash Sent from my iPhone On Oct 2, 2013, at 2:03 PM, ashish koul wrote: =IF(B3=1,"PR -1 ",IF(AND(MOD(B2,4)=0,MOD(B3,4)<>0),"PR - "& RIGHT(E2,LEN(E2)-4)+1,E2)) On Wed, Oct 2, 2013 at 1:43 PM, Avinas

Re: $$Excel-Macros$$ Periodic Formula help

2013-10-02 Thread Avinash Patil
Every 4 weeks are considered as 1 period that is the logic. And weeks are starting from sun to sat. This year was started on tuesday so last year's 2 days are also considered in this calculations. Sent from my iPhone On Oct 2, 2013, at 10:17 AM, ashish koul wrote: can u explain how what logic y

$$Excel-Macros$$ sheet updation macro

2012-02-28 Thread Avinash Patil
stead of true i want date and time to come in this format (m/d/ h:mm AM/PM) can anyone please help me to get this done by macro or something in this regards. -- Thanks and Regards, Avinash Patil "Love does not happen its a choice. Its not magic or fate, but it is when a person

$$Excel-Macros$$ Please Help me to create summary and Macro.

2012-02-01 Thread Avinash Patil
t; See attached that eliminates the need for Hyperlinks > Look in the ThisWorkbook module and the sheet module > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Avinash Patil > Sent: Monday, January 30, 2012 9:09 AM > To: excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

2012-02-01 Thread Avinash Patil
t; See attached that eliminates the need for Hyperlinks > Look in the ThisWorkbook module and the sheet module > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: Avinash Patil > Sent: Monday, January 30, 2012 9:09 AM > To: excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ Please Help me to create summary and Macro.

2012-01-29 Thread Avinash Patil
Hyperlink in last field to each row entered > ? > > I believe either you are explained too much in your post or missed to > put the crux of your issue in lime light. :) > > Regards, > DILIPandey > > On 1/27/12, Avinash Patil wrote: > > Hi Experts, > > > &

$$Excel-Macros$$ Urgent Help needed-Dashboards

2011-07-21 Thread Avinash Patil
Hi Masters, can anybody please forward me excel dashboard designs i need dashboard designs with all automations and vba work like drop downs , charts, graphs "a dashboard with full graphical and customization interface" i'll be realy greatfull to you guys please forward me the designs, Regards,