Re: $$Excel-Macros$$ last sunday of the month?

Hi For understanding this formula you need to understand formula Integer & weekday of each serial number from 1 to 7. Weekday 7 is Saturday, so first we found last day of the month, now by dividing by 7 & multiplying integer value of 7 will always give you result no a multiple of 7 i.e. Saturday

Re: $$Excel-Macros$$ last sunday of the month?

Vaibjav, Can u explain your formula? On Thu, Jun 5, 2014 at 1:00 PM, Vaibhav Joshi wrote: > hi > > use formula =INT((EOMONTH(F1,0)-1)/7)*7+1 > > where cell f1 contains any date in that month. > > Cheers!! > > > On Thu, Jun 5, 2014 at 12:55 PM, 'Hanumant' via MS EXCEL AND VBA MACROS < > excel-ma

Re: $$Excel-Macros$$ Macro Help

please paste this code in worksheet module On Fri, Jun 6, 2014 at 7:36 PM, Eugene Bernard wrote: > Dear Ashish, > > Thanks for the code !! > > I just copied and tested, it is not giving expected result. > What i am doing wrong. Please guide. > > Regards > Eugene > > > On Fri, Jun 6, 2014 at 10

Re: $$Excel-Macros$$ Similar Items

hi what you want to do, highlight similar item or get list in separate sheet?? Cheers!! On Sat, Jun 7, 2014 at 6:05 PM, Virkar,Nilesh wrote: > Dear All, > > > > I want to find out the similar items from the attached file Colum A & > Colum B. > > > > Kindly help. > > > > Regards > > Nilesh V

Re: $$Excel-Macros$$ How to apply conditional format

hi can you explain your example a bit. Cheers!! On Sat, Jun 7, 2014 at 3:55 PM, Vaibhav Joshi wrote: > Dear Expert > > I having a column (Batches manufactured during month) where in 3-4 figures > are added with "+" sign. > > If i want to apply conditional format so that I will come to total h

Re: $$Excel-Macros$$ assigning color to cells on basis of value

Hi Keertee, PFA.!!! Regards Ashish On 7 June 2014 15:28, Keertee Taneja wrote: > > > I have drawn up an this excel sheet which contains returns on a security. > It contains both positive and negative values. I want to assign different > colours to positive and negative values. How can I d

Re: $$Excel-Macros$$ Help for Macro

Cant understand what is this attachment On Sat, Jun 7, 2014 at 4:07 PM, Vaibhav Joshi wrote: > FYI > > > On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde > wrote: > >> Dear Vaibhav >> Where is attachment >> >> Regards >> Shrinivas >> >> >> On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote:

Re: $$Excel-Macros$$ Help for Macro

FYI On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde wrote: > Dear Vaibhav > Where is attachment > > Regards > Shrinivas > > > On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote: > >> hi >> >> check this.. >> >> It is dynamic.. >> >> CHeers!! >> >> >> On Fri, Jun 6, 2014 at 12:54 PM, Shriniva

Re: $$Excel-Macros$$ Help for Macro

Dear Vaibhav Where is attachment Regards Shrinivas On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote: > hi > > check this.. > > It is dynamic.. > > CHeers!! > > > On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde > wrote: > >> Dear All >> Please help me for Macro >> 1. I have a work book wh

$$Excel-Macros$$ How to apply conditional format

Dear Expert I having a column (Batches manufactured during month) where in 3-4 figures are added with "+" sign. If i want to apply conditional format so that I will come to total how many batches are manufactured during one month, how to do the same. eg 3+4+5+6=18 kg & total batches manufactured

$$Excel-Macros$$ assigning color to cells on basis of value

I have drawn up an this excel sheet which contains returns on a security. It contains both positive and negative values. I want to assign different colours to positive and negative values. How can I do both of them together. I used conditional formatting of greater than 0 it highlighted the p

Re: $$Excel-Macros$$ Help for Macro

hi check this.. It is dynamic.. CHeers!! On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde wrote: > Dear All > Please help me for Macro > 1. I have a work book which content many sheet. > 2.In a work book there is data sheet.(master sheet) sheet attached > 3.In a master sheet there is data w