$$Excel-Macros$$ Re: Weekday only from column to rows!

2011-01-30 Thread Prakash Gusain
this is done plz ignore -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread Umesh Dev
Hi sudhir, Click *Conditional formatting* tab ->Select *New Rule* -> Select *Format only cells that contain* -> click on *Format* and choose the color. Regards Umesh Dev On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote: > Dear Experts > > > please hep me for a formula which worked on co

$$Excel-Macros$$ Cell Validation using VBA

2011-01-30 Thread Rob
Can anyone help please? I have tried to apply the following VBA code in order to establish a validation within a particular cell that will measure the data entry against date values in other cells: With Selection.Validation .Delete .Add Type:=xlValidateCustom, AlertStyle:=

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread Aamir Shahzad
Result attached Aamir Shahzad On Sat, Jan 29, 2011 at 9:13 PM, sudhir kumar wrote: > Dear Experts > > > Please help see my attachement and help me. > > > thanking you > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > > P think Befo

Re: $$Excel-Macros$$ Please help

2011-01-30 Thread ashish koul
check the attachment On Sun, Jan 30, 2011 at 9:27 PM, sudhir kumar wrote: > Dear Experts > > > please hep me for a formula which worked on color. > > please see attachment. > > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > 9

Re: $$Excel-Macros$$ removing multiple data and converting column into row

2011-01-30 Thread Umesh Dev
Hi I hope the enclsd sheet will help you. Regards Umesh Dev On Sun, Jan 30, 2011 at 12:40 PM, Ms-Exl-Learner . wrote: > Hi Vikalp, > > Please refer the attached excel for solution. > > I have automated everything in formula and you need not to do any manual > input in Solution Sheet. Just yo

$$Excel-Macros$$ Please help

2011-01-30 Thread sudhir kumar
Dear Experts please hep me for a formula which worked on color. please see attachment. -- <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Sudhir Verma Asstt. Mngr. A/c's 9818479722 * P think Before you print * * ** Life is Very beautiful !!! * * ¨`•.•´¨) Always `•.¸(¨`•.

Re: $$Excel-Macros$$ Problem in excel

2011-01-30 Thread Suryaprasad
Here you go with pivot..! On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar wrote: > Dear Sir > > I have problem with excel file.Please provide the solution.(See attachment) > > Regards > > Jitender > > -- > > -- > Some

Re: $$Excel-Macros$$ Problem in excel

2011-01-30 Thread Umesh Dev
Hi jitender, Find the enclsd sheet if it could help. Regards Umesh On Sun, Jan 30, 2011 at 1:55 PM, Jitender kumar wrote: > Dear Sir > > I have problem with excel file.Please provide the solution.(See attachment) > > Regards > > Jitender > > -- > > -

$$Excel-Macros$$ Problem in excel

2011-01-30 Thread Jitender kumar
Dear Sir I have problem with excel file.Please provide the solution.(See attachment) Regards Jitender -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.